MD Contracting, Incorporated

(default) 14 queries took 74 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';34348
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'portfolio_items' AND table_schema = 'public' ORDER BY position669
3SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'portfolio_category_items' AND table_schema = 'public' ORDER BY position445
4SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'portfolio_item_images' AND table_schema = 'public' ORDER BY position887
5SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'portfolio_item_image_thumbnails' AND table_schema = 'public' ORDER BY position888
6SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'portfolio_item_image_previews' AND table_schema = 'public' ORDER BY position885
7SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'lib24watch_users' AND table_schema = 'public' ORDER BY position20206
8SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'lib24watch_module_instances' AND table_schema = 'public' ORDER BY position885
9SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'lib24watch_module_instance_users' AND table_schema = 'public' ORDER BY position555
10SELECT "Lib24watchModuleInstance"."id" AS "Lib24watchModuleInstance__id", "Lib24watchModuleInstance"."plugin" AS "Lib24watchModuleInstance__plugin", "Lib24watchModuleInstance"."handle" AS "Lib24watchModuleInstance__handle", "Lib24watchModuleInstance"."created" AS "Lib24watchModuleInstance__created", "Lib24watchModuleInstance"."modified" AS "Lib24watchModuleInstance__modified", "Lib24watchModuleInstance"."protected" AS "Lib24watchModuleInstance__protected", "Lib24watchModuleInstance"."name" AS "Lib24watchModuleInstance__name", "Lib24watchModuleInstance"."ordinal" AS "Lib24watchModuleInstance__ordinal" FROM "lib24watch_module_instances" AS "Lib24watchModuleInstance" WHERE 1 = 1 ORDER BY "ordinal" ASC, "name" ASC 111
11SELECT COUNT(*) AS "count" FROM "portfolio_items" AS "PortfolioItem" LEFT JOIN "portfolio_category_items" AS "PortfolioCategoryItem" ON ("PortfolioItem"."category_id" = "PortfolioCategoryItem"."id") WHERE "category_id" = '1' 111
12SELECT "PortfolioItem"."id" AS "PortfolioItem__id", "PortfolioItem"."category_id" AS "PortfolioItem__category_id", "PortfolioItem"."title" AS "PortfolioItem__title", "PortfolioItem"."description" AS "PortfolioItem__description", "PortfolioItem"."location" AS "PortfolioItem__location", "PortfolioItem"."updated" AS "PortfolioItem__updated", "PortfolioCategoryItem"."id" AS "PortfolioCategoryItem__id", "PortfolioCategoryItem"."title" AS "PortfolioCategoryItem__title", "PortfolioCategoryItem"."description" AS "PortfolioCategoryItem__description", "PortfolioCategoryItem"."updated" AS "PortfolioCategoryItem__updated" FROM "portfolio_items" AS "PortfolioItem" LEFT JOIN "portfolio_category_items" AS "PortfolioCategoryItem" ON ("PortfolioItem"."category_id" = "PortfolioCategoryItem"."id") WHERE "category_id" = '1' LIMIT 8881
13SELECT "PortfolioItemImage"."id" AS "PortfolioItemImage__id", "PortfolioItemImage"."item_id" AS "PortfolioItemImage__item_id", "PortfolioItemImage"."name" AS "PortfolioItemImage__name", "PortfolioItemImage"."type" AS "PortfolioItemImage__type", "PortfolioItemImage"."size" AS "PortfolioItemImage__size", "PortfolioItemImage"."filedata" AS "PortfolioItemImage__filedata", "PortfolioItemImage"."created" AS "PortfolioItemImage__created", "PortfolioItemImage"."modified" AS "PortfolioItemImage__modified" FROM "portfolio_item_images" AS "PortfolioItemImage" WHERE "PortfolioItemImage"."item_id" IN ('29', '26', '27', '28', '8', '9', '10', '12') 8813
14SELECT "PortfolioCategoryItem"."id" AS "PortfolioCategoryItem__id", "PortfolioCategoryItem"."title" AS "PortfolioCategoryItem__title" FROM "portfolio_category_items" AS "PortfolioCategoryItem" WHERE 1 = 1 330