| Typ |
Czas |
Wiadomość |
| SQL |
0.0026 |
// CONNECT [instance=site]
|
| SQL |
0.0006 |
SELECT s.* FROM bsc_sites AS s WHERE phost LIKE :phost [instance=site][params: phost=%dev-bsxcms.bsxsystem.pl%]
|
| SQL |
0.0002 |
SELECT id, pmodrewrite, purl, pcount, pcode, idsite FROM bsc_redirection WHERE idsite=:idsite [instance=site][params: idsite=1]
|
| SQL |
0.0003 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND (idr=:idr OR idr IS NULL) ORDER BY plp ASC [instance=site][params: idsite=1; idr=0]
|
| SQL |
0.0003 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=1]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=2]
|
| SQL |
0.0003 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=3]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=11]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=12]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=13]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=14]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=15]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=10]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=5]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=23]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=16]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=17]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=18]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=19]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=20]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=21]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=6]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=7]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=8]
|
| SQL |
0.0002 |
SELECT * FROM bsc_menu WHERE idsite=:idsite AND pvisible=1 AND idr=:idr ORDER BY plp ASC [instance=site][params: idsite=1; idr=9]
|
| SQL |
0.0002 |
SELECT id, pname, pid, ptable FROM bs_attachments WHERE ptable="bsc_sites" AND id=:id [instance=site][params: id=56]
|
| SQL |
0.0002 |
SELECT id, pname, pid, ptable FROM bs_attachments WHERE ptable="bsc_sites" AND id=:id [instance=site][params: id=100]
|
| SQL |
0.0002 |
SELECT d.id, d.pname, d.pcountry, d.pcurrency, d.cms_active, d.cms_price, d.cms_ratev, d.cms_idn, d.cms_default, d.cms_weight_on, d.cms_cashdelivery FROM bs_deliverytypes AS d WHERE d.cms_active=:cms_active ORDER BY d.cms_default DESC [instance=site][params: cms_active=1]
|
| SQL |
0.0002 |
SELECT p.id, p.cms_active, p.cms_price, p.cms_ratev, p.cms_idn, p.cms_default, p.pname, p.cms_online FROM bs_paymentsform AS p WHERE p.cms_active=:cms_active ORDER BY p.cms_default DESC [instance=site][params: cms_active=1]
|
| SQL |
0.0002 |
SELECT * FROM bs_pricing WHERE id=:id [instance=site][params: id=1]
|
| SQL |
0.0002 |
SELECT l.id, l.ncode, l.nname FROM bs_lang AS l WHERE (l.ncode=:ncode0 OR l.ncode=:ncode1 OR l.ncode=:ncode2 ) ORDER BY id DESC [instance=site][params: ncode0=pl; ncode1=en; ncode2=de]
|
| SQL |
0.0002 |
SELECT pname FROM bs_fields WHERE ptable LIKE :ptable [instance=site][params: ptable=bs_stockindex%]
|
| SQL |
0.0014 |
SELECT s.id, s.modyf_time, s.ptype, s.nstatus, s.nstatus, s.psymbol, s.pmansymbol, s.pquantitybox, s.pcatsymbol, s.pname, s.punit, s.pcurrency, s.pbarcodes,
s.pproducent, s.prate_v, s.prate_vz, s.psize, s.pdesc, s.pweight, s.pcolor, s.pplace, s.pwarranty, s.pcountryorigin, s.pwarrdate, s.wdesc,
s.pdiameter, s.wopc_show, s.wopc_mark, s.wopc_price, s.wopc_basket, s.wopc_showstc, s.wopc_showdst, s.wopc_spec, s.wopc_from, s.woldpriceb,
s.wseo_title, s.wseo_desc, s.wseo_keyw, s.wopc_m1, s.wopc_m2, s.wopc_m3, s.wopc_m4, s.wtags, s.wlikes, s.wnote, s.wslug, s.wseo_validity,
sp.pbrutto AS pbrutto, sp.pnetto AS pnetto, pr.pcurrency AS pcurrency, w.id AS wishlist_id, sr.idstock, sv.idowner AS variantTo,
(SELECT pname FROM bs_attachments AS a2 WHERE a2.pid=s.id AND a2.ptable="bs_stockindex" AND a2.pstatus=2 ORDER BY a2.prating DESC LIMIT 1) AS attach_pname, (SELECT SUM(sr2.pquantity-sr2.preserved) FROM bs_stockrel AS sr2 WHERE sr2.idproduct=s.id AND idstock=1 LIMIT 1) AS pquantity, bpf_001, bpf_000, bpf_004, bpf_002, bpf_003, bpf_005, bpf_006, bpf_007, bpf_009, bpf_010, bpf_012, bpf_013, bgf_000, bgf_001, bgf_002, bpf_008, bpf_014, bgf_003, s.pname_de, s.pname_en, s.pdesc_de, s.pdesc_en, s.wdesc_de, s.wdesc_en, s.wslug_de, s.wslug_en FROM bs_stockindex AS s
LEFT JOIN bs_stockprice AS sp ON s.id=sp.idproduct AND sp.idprice=:idprice
LEFT JOIN bs_pricing AS pr ON pr.id=:idprice
LEFT JOIN bs_stockrel AS sr ON s.id=sr.idproduct
LEFT JOIN bs_groups_pr AS gp ON gp.idp=s.id AND gp.ptable="bs_stockindex"
LEFT JOIN bs_stock_var AS sv ON sv.idproduct=s.id
LEFT JOIN bsc_wishlist AS w ON w.idproduct=s.id AND w.pidcontractor=:idsuser
WHERE sr.idstock=:idm AND s.wslug=:wslug AND s.wopc_show=:wopc_show GROUP BY s.id LIMIT 1 [instance=site][params: wslug=wezownica-moonshine; wopc_show=1; idprice=1; idsuser=0; idm=1]
|
| SQL |
0.0002 |
SELECT id, pdate, pnetto, pbrutto FROM bs_stockprice_hs WHERE idprice=:idprice AND idproduct=:idproduct ORDER BY pdate DESC, id DESC [instance=site][params: idprice=1; idproduct=13]
|
| SQL |
0.0002 |
SELECT pname FROM bs_fields WHERE ptable LIKE :ptable [instance=site][params: ptable=bs_attachments]
|
| SQL |
0.0004 |
SELECT a.id, a.ptitle, a.pname, a.plocation, a.pstatus, a.ptable, a.pid, a.pdesc, a.prating, a.purl, a.porder, a.ppagephoto FROM bs_attachments AS a
LEFT JOIN bs_groups_pr AS gp ON gp.idp=a.id AND gp.ptable="bs_attachments"
WHERE a.pstatus=:pstatus AND a.ptable=:ptable AND a.pid=:pid GROUP BY a.id ORDER BY a.prating DESC [instance=site][params: pstatus=2; ptable=bs_stockindex; pid=13]
|
| SQL |
0.0002 |
SELECT s.id, s.idprod, s.idattr, s.idattrpr, s.mprice, a.mname, p.mname AS aname, a.pident FROM bsc_stockattrs AS s
LEFT JOIN bsc_attributes AS a ON a.id=s.idattr
LEFT JOIn bsc_attributes_pr AS p ON p.id=s.idattrpr
WHERE s.idprod=:idprod ORDER BY s.id ASC [instance=site][params: idprod=13]
|
| SQL |
0.0003 |
SELECT * FROM bsc_articles WHERE pmodrewrite=:id AND (pstatus=1 OR pstatus=2) AND (idsite=:idsite OR idsite=0 OR idsite IS NULL) ORDER BY idsite DESC [instance=site][params: id=shop; idsite=1]
|
| SQL |
0.0003 |
SELECT * FROM bsc_articles_pr WHERE iddoc=:articleId AND nstatus=1 ORDER BY forder DESC [instance=site][params: articleId=5]
|
| SQL |
0.0002 |
SELECT * FROM bs_attachments WHERE pid = :pid AND ptable = "bsc_articles_pr" AND pstatus = 2 ORDER BY prating DESC, porder ASC, id ASC [instance=site][params: pid=28]
|
| SQL |
0.0002 |
SELECT * FROM bs_attachments WHERE pid = :pid AND ptable = "bsc_articles" AND pstatus = 2 ORDER BY prating DESC, porder ASC, id ASC [instance=site][params: pid=5]
|
| SQL |
0.0002 |
SELECT pname FROM bs_fields WHERE ptable LIKE :ptable [instance=site][params: ptable=bs_attachments]
|
| SQL |
0.0002 |
SELECT pname FROM bs_fields WHERE ptable LIKE :ptable [instance=site][params: ptable=bs_attachments]
|
| SQL |
0.0010 |
SELECT s.id, s.modyf_time, s.ptype, s.nstatus, s.nstatus, s.psymbol, s.pmansymbol, s.pquantitybox, s.pcatsymbol, s.pname, s.punit, s.pcurrency, s.pbarcodes,
s.pproducent, s.prate_v, s.prate_vz, s.psize, s.pdesc, s.pweight, s.pcolor, s.pplace, s.pwarranty, s.pcountryorigin, s.pwarrdate, s.wdesc,
s.pdiameter, s.wopc_show, s.wopc_mark, s.wopc_price, s.wopc_basket, s.wopc_showstc, s.wopc_showdst, s.wopc_spec, s.wopc_from, s.woldpriceb,
s.wseo_title, s.wseo_desc, s.wseo_keyw, s.wopc_m1, s.wopc_m2, s.wopc_m3, s.wopc_m4, s.wtags, s.wlikes, s.wnote, s.wslug, s.wseo_validity,
sp.pbrutto AS pbrutto, sp.pnetto AS pnetto, pr.pcurrency AS pcurrency, gr.pname AS group_name,
gr.wslug AS group_slug, w.id AS wishlist_id, sr.idstock,
(SELECT pname FROM bs_attachments AS a2 WHERE a2.pid=s.id AND a2.ptable="bs_stockindex" AND a2.pstatus=2 ORDER BY a2.prating DESC LIMIT 1) AS attach_pname, (SELECT SUM(sr2.pquantity-sr2.preserved) FROM bs_stockrel AS sr2 WHERE sr2.idproduct=s.id AND idstock=1 LIMIT 1) AS pquantity, bpf_001, bpf_000, bpf_004, bpf_002, bpf_003, bpf_005, bpf_006, bpf_007, bpf_009, bpf_010, bpf_012, bpf_013, bgf_000, bgf_001, bgf_002, bpf_008, bpf_014, bgf_003, s.pname_de, s.pname_en, s.pdesc_de, s.pdesc_en, s.wdesc_de, s.wdesc_en, s.wslug_de, s.wslug_en, gr.pname_de AS group_name, gr.wslug AS group_slug_de, gr.pname_en AS group_name, gr.wslug AS group_slug_en FROM bs_stockindex AS s
LEFT JOIN bs_stockprice AS sp ON s.id=sp.idproduct AND sp.idprice=:idprice
LEFT JOIN bs_pricing AS pr ON pr.id=:idprice
LEFT JOIN bs_stockrel AS sr ON s.id=sr.idproduct
LEFT JOIN bs_groups_pr AS gp ON gp.idp=s.id AND gp.ptable="bs_stockindex"
LEFT JOIN bs_groups AS gr ON gr.id=gp.idg
LEFT JOIN bs_stock_var AS sv ON sv.idproduct=s.id
LEFT JOIN bs_si_recom AS rec ON rec.idrelproduct=s.id
LEFT JOIN bsc_wishlist AS w ON w.idproduct=s.id AND w.pidcontractor=:idsuser
WHERE sr.idstock=:idm AND s.wopc_show=:wopc_show AND sv.idowner=:idvariant GROUP BY s.id ORDER BY s.wlp DESC, s.id DESC [instance=site][params: wopc_show=1; idvariant=13; idprice=1; idsuser=0; idm=1]
|
| SQL |
0.0002 |
SELECT f.id, f.ptable, f.pname, f.pcaption, f.ptype, f.pmtype, f.pdefault, f.pattr, f.plp FROM bs_fields AS f WHERE f.ptable LIKE :ptable ORDER BY id DESC [instance=site][params: ptable=%bs_stockindex#%]
|
| SQL |
0.0007 |
SELECT g.id, g.pname, g.tblname, g.idparent, g.idkids, g.widen, g.wslug, g.wspos, g.wicon, g.wtype, g.wvisible, g.wspec, g.pseo_title, g.pseo_desc, g.pseo_keyw, g2.pname AS parent_name,
(SELECT pname FROM bs_attachments AS a WHERE a.pid = g.id AND a.ptable = "bs_groups" AND a.pstatus=2 ORDER BY a.prating DESC LIMIT 1) AS apname, g.pname_de, g.pname_en, g.wslug_de, g.wslug_en FROM bs_groups AS g
LEFT JOIN bs_groups AS g2 ON g2.id = g.idparent
LEFT JOIN bs_groups_pr AS gp ON gp.idg = g.id
LEFT JOIN bs_attachments AS a ON a.pid = g.id AND a.ptable = "bs_groups"
WHERE g.tblname=:tblname AND gp.idp=:idp GROUP BY g.id ORDER BY g.wspos ASC, g.id ASC [instance=site][params: tblname=bs_stockindex; idp=13]
|
| SQL |
0.0015 |
SELECT s.id, s.modyf_time, s.ptype, s.nstatus, s.nstatus, s.psymbol, s.pmansymbol, s.pquantitybox, s.pcatsymbol, s.pname, s.punit, s.pcurrency, s.pbarcodes,
s.pproducent, s.prate_v, s.prate_vz, s.psize, s.pdesc, s.pweight, s.pcolor, s.pplace, s.pwarranty, s.pcountryorigin, s.pwarrdate, s.wdesc,
s.pdiameter, s.wopc_show, s.wopc_mark, s.wopc_price, s.wopc_basket, s.wopc_showstc, s.wopc_showdst, s.wopc_spec, s.wopc_from, s.woldpriceb,
s.wseo_title, s.wseo_desc, s.wseo_keyw, s.wopc_m1, s.wopc_m2, s.wopc_m3, s.wopc_m4, s.wtags, s.wlikes, s.wnote, s.wslug, s.wseo_validity,
sp.pbrutto AS pbrutto, sp.pnetto AS pnetto, pr.pcurrency AS pcurrency, gr.pname AS group_name,
gr.wslug AS group_slug, w.id AS wishlist_id, sr.idstock,
(SELECT pname FROM bs_attachments AS a2 WHERE a2.pid=s.id AND a2.ptable="bs_stockindex" AND a2.pstatus=2 ORDER BY a2.prating DESC LIMIT 1) AS attach_pname, (SELECT SUM(sr2.pquantity-sr2.preserved) FROM bs_stockrel AS sr2 WHERE sr2.idproduct=s.id AND idstock=1 LIMIT 1) AS pquantity, bpf_001, bpf_000, bpf_004, bpf_002, bpf_003, bpf_005, bpf_006, bpf_007, bpf_009, bpf_010, bpf_012, bpf_013, bgf_000, bgf_001, bgf_002, bpf_008, bpf_014, bgf_003, s.pname_de, s.pname_en, s.pdesc_de, s.pdesc_en, s.wdesc_de, s.wdesc_en, s.wslug_de, s.wslug_en, gr.pname_de AS group_name, gr.wslug AS group_slug_de, gr.pname_en AS group_name, gr.wslug AS group_slug_en FROM bs_stockindex AS s
LEFT JOIN bs_stockprice AS sp ON s.id=sp.idproduct AND sp.idprice=:idprice
LEFT JOIN bs_pricing AS pr ON pr.id=:idprice
LEFT JOIN bs_stockrel AS sr ON s.id=sr.idproduct
LEFT JOIN bs_groups_pr AS gp ON gp.idp=s.id AND gp.ptable="bs_stockindex"
LEFT JOIN bs_groups AS gr ON gr.id=gp.idg
LEFT JOIN bs_stock_var AS sv ON sv.idproduct=s.id
LEFT JOIN bs_si_recom AS rec ON rec.idrelproduct=s.id
LEFT JOIN bsc_wishlist AS w ON w.idproduct=s.id AND w.pidcontractor=:idsuser
WHERE sr.idstock=:idm AND s.wopc_show=:wopc_show AND rec.idproduct=:related_to GROUP BY s.id ORDER BY s.wlp DESC, s.id DESC [instance=site][params: wopc_show=1; related_to=13; idprice=1; idsuser=0; idm=1]
|
| SQL |
0.0005 |
SELECT COUNT(DISTINCT s.id) AS cnt FROM bs_stockindex AS s
LEFT JOIN bs_stockprice AS sp ON s.id=sp.idproduct AND sp.idprice=:idprice
LEFT JOIN bs_pricing AS pr ON pr.id=:idprice
LEFT JOIN bs_stockrel AS sr ON s.id=sr.idproduct
LEFT JOIN bs_groups_pr AS gp ON gp.idp=s.id AND gp.ptable="bs_stockindex"
LEFT JOIN bs_groups AS gr ON gr.id=gp.idg
LEFT JOIN bs_stock_var AS sv ON sv.idproduct=s.id
LEFT JOIN bs_si_recom AS rec ON rec.idrelproduct=s.id
LEFT JOIN bsc_wishlist AS w ON w.idproduct=s.id AND w.pidcontractor=:idsuser
WHERE sr.idstock=:idm AND s.wopc_show=:wopc_show AND rec.idproduct=:related_to [instance=site][params: wopc_show=1; related_to=13; idprice=1; idsuser=0; idm=1]
|
| SQL |
0.0002 |
SELECT id, pdate, pnetto, pbrutto FROM bs_stockprice_hs WHERE idprice=:idprice AND idproduct=:idproduct ORDER BY pdate DESC, id DESC [instance=site][params: idprice=1; idproduct=22]
|
| SQL |
0.0002 |
SELECT id, pdate, pnetto, pbrutto FROM bs_stockprice_hs WHERE idprice=:idprice AND idproduct=:idproduct ORDER BY pdate DESC, id DESC [instance=site][params: idprice=1; idproduct=9]
|
| SQL |
0.0002 |
SELECT pname, pnip, pregon, pkrs, pstreet, pstreet_n1, ppostcode, ppost, pcity, pprovince, pdistrict, pcommunity, pcountry, pphone1, pphone2, pemail, pwww FROM bs_company WHERE id=:idcompany LIMIT 1 [instance=site][params: idcompany=1]
|
| SQL |
0.0002 |
SELECT * FROM bs_banks WHERE idcompany=:idcompany ORDER BY pdefault DESC [instance=site][params: idcompany=1]
|
| SQL |
0.0002 |
SELECT a.id, a.fdellock, a.idsite, a.ptitle, a.pauthor, a.modyf_time, a.pmodrewrite, a.pstatus, a.pbody, a.ptpl, a.pactivetab, a.pseo_title, a.pseo_desc, a.pseo_keyw, a.pseo_validity FROM bsc_articles AS a WHERE a.id=:id LIMIT 1 [instance=site][params: id=1]
|