| 0.0005 |
SELECT pg_advisory_xact_lock(hashtext('bqauguq9bme5pvvtnj24ruptg5sridon')) AS ok
|
| 0.0009 |
SELECT "data"
FROM "unity"."temp_sessions3"
WHERE "id" = 'bqauguq9bme5pvvtnj24ruptg5sridon'
|
| 0.0003 |
SELECT *
FROM "unity"."home_vars"
|
| 0.0015 |
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.0044 |
SELECT *
FROM "unity"."rates"
|
| 0.0004 |
SELECT *
FROM "unity"."home_media"
WHERE "status_id" = 1
AND "etype" = 'logo'
AND now() between starts_at::date and ends_at::date
|
| 0.0054 |
SELECT *
FROM unity.cache
where key='main_categories_0' AND updated + (live_time_seconds::text||' second')::INTERVAL > now()
|
| 0.0096 |
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.0021 |
SELECT plainto_tsquery('Смарт часовник')::text q;
|
| 0.1400 |
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['%смарт%','%часовник%'])
GROUP BY "c"."id", "c"."ename", "c"."slug"
ORDER BY 4 desc
|
| 0.0002 |
SELECT plainto_tsquery('Смарт часовник')::text q;
|
| 0.9683 |
SELECT pr.*, 'search-bqauguq9bme5pvvtnj24ruptg5sridon' as session_id, ts_rank( '{0.1, 0.3, 0.6, 1}', pr.isearch, plainto_tsquery('Смарт часовник')) AS rank, ts_rank( '{0.1, 0.3, 0.6, 1}', pr.isearch, plainto_tsquery('Смарт')) / (CASE WHEN pr.from_supp=1 THEN 2 ELSE 1 END)+ts_rank( '{0.1, 0.3, 0.6, 1}', pr.isearch, plainto_tsquery('часовник')) / (CASE WHEN pr.from_supp=1 THEN 2 ELSE 1 END) trank, strip(pr.isearch)::text like all (array['%смарт%', '%часовник%']) 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['%смарт%','%часовник%'])
ORDER BY first_order asc, trank desc, s_and desc, rank desc, pr.created desc
LIMIT 30 OFFSET 720
|
| 0.0005 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id
FROM "unity"."product_image"
WHERE "product_id" = '5070450'
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" = '5168844'
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" = '5168843'
AND status_id > 0 and status_id<5
ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0023 |
SELECT replace(file_name, 'http://i.jarcomputers', 'https://p.jarcomputers') file_name, status_id
FROM "unity"."product_image"
WHERE "product_id" = '5006242'
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" = '5006241'
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" = '5006244'
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" = '5006243'
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" = '5069946'
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" = '4858947'
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" = '4554279'
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" = '4481830'
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" = '4205518'
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" = '3122432'
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" = '2556070'
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" = '4518422'
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" = '4518421'
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" = '4518419'
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" = '4518418'
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" = '4518417'
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" = '4518415'
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" = '4518414'
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" = '4518413'
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" = '4518412'
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" = '4518411'
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" = '4518410'
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" = '4518407'
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" = '4518406'
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" = '4518405'
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" = '4518430'
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" = '4518429'
AND status_id > 0 and status_id<5
ORDER BY "status_id" DESC, "sorder" ASC
|
| 0.0001 |
SELECT plainto_tsquery('Смарт часовник')::text q;
|
| 0.8962 |
SELECT COUNT(*) AS "numrows"
FROM "unity"."product_site_with_supp" "pr"
WHERE strip(pr.isearch)::text like all (array['%смарт%','%часовник%'])
|
| 0.0020 |
SELECT *
FROM "unity"."search"
WHERE lower(q)=lower('Смарт часовник')
|
| 0.0035 |
SELECT *
FROM "unity"."url_seo_data"
WHERE "url" = '/search?page=25'
|
» Резултати от търсенене на "Смарт часовник"
