| 0.0030 |
SELECT 1 FROM "unity"."temp_sessions3" WHERE "id" = '8rnrkcme6vmb5m3uit75qolj7fmir504'
|
| 0.0003 |
SELECT pg_advisory_xact_lock(hashtext('8rnrkcme6vmb5m3uit75qolj7fmir504')) AS ok
|
| 0.0048 |
SELECT "data" FROM "unity"."temp_sessions3" WHERE "id" = '8rnrkcme6vmb5m3uit75qolj7fmir504'
|
| 0.0027 |
SELECT * FROM "unity"."home_vars"
|
| 0.0049 |
SELECT "camp"."ename", "camp"."img", "camp"."url" FROM "unity"."campaign" "camp" WHERE now() between camp.starts_at and camp.ends_at AND camp.on_slider=1 and camp.img is not null AND "camp"."type_status_id" = 9 AND "camp"."status_id" = 1 ORDER BY "camp"."starts_at" DESC
|
| 0.0047 |
SELECT * FROM "unity"."rates"
|
| 0.0025 |
SELECT * FROM "unity"."home_media" WHERE "status_id" = 1 AND "etype" = 'logo' AND now() between starts_at::date and ends_at::date
|
| 0.0029 |
SELECT * FROM unity.cache where key='main_categories_0' AND updated + (live_time_seconds::text||' second')::INTERVAL > now()
|
| 0.0068 |
SELECT "c"."id", "c"."category_id", "c"."ename", "c"."sub_categories_id", "c"."product_count" AS "cntr", "c"."url", "c"."show_cat", "c"."sections", "c"."section", "ci"."image_bg", "c"."link_id", "c"."canonical", "c"."slug" FROM "unity"."category_site" "c" LEFT JOIN unity.category_image ci ON ci.category_id = c.id WHERE "c"."status_id" = 1 ORDER BY "c"."section", "c"."sorder", "c"."id", "c"."ename"
|
| 0.0006 |
SELECT plainto_tsquery('usb type c')::text q;
|
| 0.2914 |
SELECT c.id, c.ename, c.slug, count(c.id) rank FROM "unity"."product_site" "p" JOIN unity.category_site c ON c.id=p.category_id OR p.id = any(c.product_ids) WHERE strip(p.isearch)::text like all (array['%usb%','%type%','%c%']) GROUP BY "c"."id", "c"."ename", "c"."slug" ORDER BY 4 desc
|
| 0.0003 |
SELECT plainto_tsquery('usb type c')::text q;
|
| 1.5420 |
SELECT pr.*, 'search-8rnrkcme6vmb5m3uit75qolj7fmir504' as session_id, ts_rank( '{0.1, 0.3, 0.6, 1}', pr.isearch, plainto_tsquery('usb type c')) AS rank, ts_rank( '{0.1, 0.3, 0.6, 1}', pr.isearch, plainto_tsquery('usb')) / (CASE WHEN pr.from_supp=1 THEN 2 ELSE 1 END)+ts_rank( '{0.1, 0.3, 0.6, 1}', pr.isearch, plainto_tsquery('type')) / (CASE WHEN pr.from_supp=1 THEN 2 ELSE 1 END)+ts_rank( '{0.1, 0.3, 0.6, 1}', pr.isearch, plainto_tsquery('c')) / (CASE WHEN pr.from_supp=1 THEN 2 ELSE 1 END) trank, strip(pr.isearch)::text like all (array['%usb%', '%type%', '%c%']) s_and, 'https://www.jarcomputers.com/images/loading2.gif' img, pp.props FROM "unity"."product_site_with_supp" "pr" LEFT JOIN unity.mvw_product_properties pp ON pp.id=pr.id and pr.from_supp=0 WHERE strip(pr.isearch)::text like all (array['%usb%','%type%','%c%']) ORDER BY first_order asc, trank desc, s_and desc, rank desc, pr.created desc LIMIT 30 OFFSET 14100
|
| 0.0025 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2675681' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0003 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1125230' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0003 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '877459' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '857149' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0003 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1299032' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0022 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1240328' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1380266' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0003 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2510059' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '5073874' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2606448' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2556455' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0003 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2788711' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2162012' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '735844' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2788771' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2733510' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0003 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1127121' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0003 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2162049' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '821700' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2326437' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2162104' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1215433' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2282437' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2511597' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1625917' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2161997' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '737422' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0001 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1985959' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0001 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '1706701' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0002 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id FROM "unity"."product_image" WHERE "product_id" = '2162003' AND status_id > 0 and status_id<5 ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0022 |
SELECT plainto_tsquery('usb type c')::text q;
|
| 0.8508 |
SELECT COUNT(*) AS "numrows" FROM "unity"."product_site_with_supp" "pr" WHERE strip(pr.isearch)::text like all (array['%usb%','%type%','%c%'])
|
| 0.0032 |
SELECT * FROM "unity"."search" WHERE lower(q)=lower('usb type c')
|
| 0.0003 |
SELECT * FROM "unity"."url_seo_data" WHERE "url" = '/search?page=471'
|