Symfony Profiler

SHOW FULL TABLES 
WHERE 
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT 
  version 
FROM 
  pimcore_migrations 
WHERE 
  migration_set = ? 
  AND version = ?

SELECT version FROM pimcore_migrations WHERE migration_set = 'PimcoreEcommerceFrameworkBundle' AND version = '00000001';

SHOW TABLES LIKE "bundle_number_sequence_generator_register"

SHOW TABLES LIKE "bundle_number_sequence_generator_register";

SHOW TABLES LIKE "bundle_number_sequence_generator_randomregister"

SHOW TABLES LIKE "bundle_number_sequence_generator_randomregister";

SHOW FULL TABLES 
WHERE 
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT 
  version 
FROM 
  pimcore_migrations 
WHERE 
  migration_set = ? 
  AND version = ?

SELECT version FROM pimcore_migrations WHERE migration_set = 'PimcoreCustomerManagementFrameworkBundle' AND version = '00000001';

SELECT 
  * 
FROM 
  users_permission_definitions 
WHERE 
  `key` = ? 
LIMIT 
  1

SELECT * FROM users_permission_definitions WHERE `key`='plugin_bb_pim'  LIMIT 1;

SHOW FULL TABLES 
WHERE 
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT 
  version 
FROM 
  pimcore_migrations 
WHERE 
  migration_set = ? 
  AND version = ?

SELECT version FROM pimcore_migrations WHERE migration_set = 'BlackbitDataDirectorBundle' AND version = '00000001';

SHOW FULL TABLES 
WHERE 
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT 
  version 
FROM 
  pimcore_migrations 
WHERE 
  migration_set = ? 
  AND version IN (
    '00000001', '20170608151600', '20170919134100', 
    '20181101114350', '20181126122530', 
    '20190129100300', '20190207083100', 
    '20190326155800', '20190508154929', 
    '20190613075129', '20190801100038', 
    '20190814080323', '20190916120217', 
    '20191001091641', '20191112154928', 
    '20200217111429', '20200414150938', 
    '20200421155253', '20200427115927', 
    '20200522144211', '20200615154532', 
    '20200630113828', '20200710083717', 
    '20200713090834', '20200730125425', 
    '20200817114348', '20200908074656', 
    '20200915114911', '20201010095728', 
    '20201123095337', '20210112084011', 
    '20210119144131', '20210310073948', 
    '20210329165421', '20210408074528', 
    '20210503083414', '20210506082452', 
    '20210609134913', '20210628122431', 
    '20210806140521', '20210809132913', 
    '20210809135546', '20210812083344', 
    '20210816121737', '20210823222451', 
    '20210928213341', '20211029075848', 
    '20211208181022', '20220103131714', 
    '20220111075249', '20220112120731', 
    '20220120135252', '20220425151051', 
    '20220531100222', '20220608131751', 
    '20220615123042', '20220620191354', 
    '20220622114948', '20220623072422', 
    '20220627115943', '20220629113618', 
    '20220701165353', '20220714114643', 
    '20220823200131', '20221018163822'
  ) 
ORDER BY 
  version DESC 
LIMIT 
  1

SELECT version FROM pimcore_migrations WHERE migration_set = 'BlackbitDataDirectorBundle' AND version IN ('00000001', '20170608151600', '20170919134100', '20181101114350', '20181126122530', '20190129100300', '20190207083100', '20190326155800', '20190508154929', '20190613075129', '20190801100038', '20190814080323', '20190916120217', '20191001091641', '20191112154928', '20200217111429', '20200414150938', '20200421155253', '20200427115927', '20200522144211', '20200615154532', '20200630113828', '20200710083717', '20200713090834', '20200730125425', '20200817114348', '20200908074656', '20200915114911', '20201010095728', '20201123095337', '20210112084011', '20210119144131', '20210310073948', '20210329165421', '20210408074528', '20210503083414', '20210506082452', '20210609134913', '20210628122431', '20210806140521', '20210809132913', '20210809135546', '20210812083344', '20210816121737', '20210823222451', '20210928213341', '20211029075848', '20211208181022', '20220103131714', '20220111075249', '20220112120731', '20220120135252', '20220425151051', '20220531100222', '20220608131751', '20220615123042', '20220620191354', '20220622114948', '20220623072422', '20220627115943', '20220629113618', '20220701165353', '20220714114643', '20220823200131', '20221018163822') ORDER BY version DESC LIMIT 1;

SELECT 
  id, 
  (
    CASE WHEN expire IS NULL 
    OR expire > ? THEN data ELSE NULL END
  ) as data 
FROM 
  cache 
WHERE 
  id IN (?)

SELECT id, 
          (CASE WHEN expire IS NULL OR expire > 1755360463 THEN data ELSE NULL END) as data
            FROM cache WHERE id IN ('translation_data_admin_en');