SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001185s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.169982s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068396 LIMIT 5 [ RunTime:0.085408s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068396 ORDER BY `minOrder` ASC [ RunTime:0.050777s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068396 ORDER BY `unit` DESC [ RunTime:0.050950s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068396 LIMIT 2 [ RunTime:0.026558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068396 ORDER BY `minOrder` ASC [ RunTime:0.242768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606373 LIMIT 5 [ RunTime:0.080954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606373 ORDER BY `minOrder` ASC [ RunTime:0.069761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606373 ORDER BY `unit` DESC [ RunTime:0.051146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606373 LIMIT 2 [ RunTime:0.050837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606373 ORDER BY `minOrder` ASC [ RunTime:0.115956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11445712 LIMIT 5 [ RunTime:0.051564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11445712 ORDER BY `minOrder` ASC [ RunTime:0.050912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11445712 ORDER BY `unit` DESC [ RunTime:0.063713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11445712 LIMIT 2 [ RunTime:0.050876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11445712 ORDER BY `minOrder` ASC [ RunTime:0.050966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662399 LIMIT 5 [ RunTime:0.114801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662399 ORDER BY `minOrder` ASC [ RunTime:0.118225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19662399 ORDER BY `unit` DESC [ RunTime:0.050542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19662399 LIMIT 2 [ RunTime:0.048700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662399 ORDER BY `minOrder` ASC [ RunTime:0.031374s ]
select * from pdf where partno='1082140000' and brandshort='Weidmüller' limit 1 [ RunTime:0.021157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975486 LIMIT 5 [ RunTime:0.051503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975486 ORDER BY `minOrder` ASC [ RunTime:0.051117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975486 ORDER BY `unit` DESC [ RunTime:0.040927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975486 LIMIT 2 [ RunTime:0.102279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975486 ORDER BY `minOrder` ASC [ RunTime:0.155842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705932 LIMIT 5 [ RunTime:0.197338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705932 ORDER BY `minOrder` ASC [ RunTime:0.050944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705932 ORDER BY `unit` DESC [ RunTime:0.054099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705932 LIMIT 2 [ RunTime:0.105700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705932 ORDER BY `minOrder` ASC [ RunTime:0.078584s ]
select * from pdf where partno='10821S' and brandshort='Aven Tools' limit 1 [ RunTime:0.130786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705931 LIMIT 5 [ RunTime:0.042276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705931 ORDER BY `minOrder` ASC [ RunTime:0.052688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705931 ORDER BY `unit` DESC [ RunTime:0.054657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705931 LIMIT 2 [ RunTime:0.138085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705931 ORDER BY `minOrder` ASC [ RunTime:0.026150s ]
select * from pdf where partno='10821F' and brandshort='Aven Tools' limit 1 [ RunTime:0.051860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225694 LIMIT 5 [ RunTime:0.039191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225694 ORDER BY `minOrder` ASC [ RunTime:0.064617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225694 ORDER BY `unit` DESC [ RunTime:0.025553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225694 LIMIT 2 [ RunTime:0.079912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225694 ORDER BY `minOrder` ASC [ RunTime:0.052258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666039 LIMIT 5 [ RunTime:0.087261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666039 ORDER BY `minOrder` ASC [ RunTime:0.092974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19666039 ORDER BY `unit` DESC [ RunTime:0.080286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19666039 LIMIT 2 [ RunTime:0.131767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666039 ORDER BY `minOrder` ASC [ RunTime:0.045131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264374 LIMIT 5 [ RunTime:0.030832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264374 ORDER BY `minOrder` ASC [ RunTime:0.118572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264374 ORDER BY `unit` DESC [ RunTime:0.095019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264374 LIMIT 2 [ RunTime:0.009749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264374 ORDER BY `minOrder` ASC [ RunTime:0.075342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264373 LIMIT 5 [ RunTime:0.030014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264373 ORDER BY `minOrder` ASC [ RunTime:0.030011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264373 ORDER BY `unit` DESC [ RunTime:0.050277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264373 LIMIT 2 [ RunTime:0.094314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264373 ORDER BY `minOrder` ASC [ RunTime:0.011710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982122 LIMIT 5 [ RunTime:0.040094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982122 ORDER BY `minOrder` ASC [ RunTime:0.080365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982122 ORDER BY `unit` DESC [ RunTime:0.089796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982122 LIMIT 2 [ RunTime:0.025171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982122 ORDER BY `minOrder` ASC [ RunTime:0.004808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981881 LIMIT 5 [ RunTime:0.037653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981881 ORDER BY `minOrder` ASC [ RunTime:0.017891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981881 ORDER BY `unit` DESC [ RunTime:0.000314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981881 LIMIT 2 [ RunTime:0.047131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981881 ORDER BY `minOrder` ASC [ RunTime:0.016938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979968 LIMIT 5 [ RunTime:0.045958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979968 ORDER BY `minOrder` ASC [ RunTime:0.040705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979968 ORDER BY `unit` DESC [ RunTime:0.034278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979968 LIMIT 2 [ RunTime:0.030283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979968 ORDER BY `minOrder` ASC [ RunTime:0.025622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979680 LIMIT 5 [ RunTime:0.059455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979680 ORDER BY `minOrder` ASC [ RunTime:0.040551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979680 ORDER BY `unit` DESC [ RunTime:0.033094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979680 LIMIT 2 [ RunTime:0.015039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979680 ORDER BY `minOrder` ASC [ RunTime:0.012260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975868 LIMIT 5 [ RunTime:0.002285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975868 ORDER BY `minOrder` ASC [ RunTime:0.017853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975868 ORDER BY `unit` DESC [ RunTime:0.008435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975868 LIMIT 2 [ RunTime:0.024444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975868 ORDER BY `minOrder` ASC [ RunTime:0.010033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18787495 LIMIT 5 [ RunTime:0.120389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787495 ORDER BY `minOrder` ASC [ RunTime:0.031967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18787495 ORDER BY `unit` DESC [ RunTime:0.026107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18787495 LIMIT 2 [ RunTime:0.053745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787495 ORDER BY `minOrder` ASC [ RunTime:0.044588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780287 LIMIT 5 [ RunTime:0.014663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780287 ORDER BY `minOrder` ASC [ RunTime:0.013888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780287 ORDER BY `unit` DESC [ RunTime:0.010529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780287 LIMIT 2 [ RunTime:0.017740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780287 ORDER BY `minOrder` ASC [ RunTime:0.019342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773869 LIMIT 5 [ RunTime:0.051713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773869 ORDER BY `minOrder` ASC [ RunTime:0.048887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773869 ORDER BY `unit` DESC [ RunTime:0.048585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773869 LIMIT 2 [ RunTime:0.061382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773869 ORDER BY `minOrder` ASC [ RunTime:0.016952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772128 LIMIT 5 [ RunTime:0.029387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772128 ORDER BY `minOrder` ASC [ RunTime:0.019854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772128 ORDER BY `unit` DESC [ RunTime:0.038616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772128 LIMIT 2 [ RunTime:0.021780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772128 ORDER BY `minOrder` ASC [ RunTime:0.011528s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022433s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562939 LIMIT 5 [ RunTime:0.039322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562939 ORDER BY `minOrder` ASC [ RunTime:0.024708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562939 ORDER BY `unit` DESC [ RunTime:0.028146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562939 LIMIT 2 [ RunTime:0.016662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562939 ORDER BY `minOrder` ASC [ RunTime:0.021463s ]
select * from pdf where partno='10821CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.033511s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10821CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.017640s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562939 AND `partno` = '10821CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068396 [ RunTime:0.032414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488916 LIMIT 5 [ RunTime:0.008090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488916 ORDER BY `minOrder` ASC [ RunTime:0.009460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488916 ORDER BY `unit` DESC [ RunTime:0.009489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488916 LIMIT 2 [ RunTime:0.010914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488916 ORDER BY `minOrder` ASC [ RunTime:0.006235s ]
select * from pdf where partno='1082110000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082110000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004914s ]
SELECT `id` FROM `stock` WHERE `id` <> 60488916 AND `partno` = '1082110000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11445712 [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488075 LIMIT 5 [ RunTime:0.012368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488075 ORDER BY `minOrder` ASC [ RunTime:0.011023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488075 ORDER BY `unit` DESC [ RunTime:0.042820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488075 LIMIT 2 [ RunTime:0.038283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488075 ORDER BY `minOrder` ASC [ RunTime:0.008275s ]
select * from pdf where partno='1082140000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082140000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004507s ]
SELECT `id` FROM `stock` WHERE `id` <> 60488075 AND `partno` = '1082140000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.024031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662399 [ RunTime:0.020235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58557015 LIMIT 5 [ RunTime:0.011633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557015 ORDER BY `minOrder` ASC [ RunTime:0.015633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58557015 ORDER BY `unit` DESC [ RunTime:0.016385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58557015 LIMIT 2 [ RunTime:0.041099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557015 ORDER BY `minOrder` ASC [ RunTime:0.008326s ]
select * from pdf where partno='10821F' and brandshort='Aven Tools' limit 1 [ RunTime:0.002149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10821F' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.001153s ]
SELECT `id` FROM `stock` WHERE `id` <> 58557015 AND `partno` = '10821F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.000847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705931 [ RunTime:0.011802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58557267 LIMIT 5 [ RunTime:0.007360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557267 ORDER BY `minOrder` ASC [ RunTime:0.010886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58557267 ORDER BY `unit` DESC [ RunTime:0.012855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58557267 LIMIT 2 [ RunTime:0.017966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557267 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='10821S' and brandshort='Aven Tools' limit 1 [ RunTime:0.002489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10821S' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.002855s ]
SELECT `id` FROM `stock` WHERE `id` <> 58557267 AND `partno` = '10821S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.009597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705932 [ RunTime:0.013905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63192025 LIMIT 5 [ RunTime:0.003065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63192025 ORDER BY `minOrder` ASC [ RunTime:0.007541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63192025 ORDER BY `unit` DESC [ RunTime:0.002167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63192025 LIMIT 2 [ RunTime:0.002600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63192025 ORDER BY `minOrder` ASC [ RunTime:0.008206s ]
select * from pdf where partno='1082132' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082132' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001119s ]
SELECT `id` FROM `stock` WHERE `id` <> 63192025 AND `partno` = '1082132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975486 [ RunTime:0.014658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63337266 LIMIT 5 [ RunTime:0.011794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337266 ORDER BY `minOrder` ASC [ RunTime:0.007890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63337266 ORDER BY `unit` DESC [ RunTime:0.012160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63337266 LIMIT 2 [ RunTime:0.015511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337266 ORDER BY `minOrder` ASC [ RunTime:0.007099s ]
select * from pdf where partno='1082138' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082138' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006069s ]
SELECT `id` FROM `stock` WHERE `id` <> 63337266 AND `partno` = '1082138' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225694 [ RunTime:0.001187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805721 LIMIT 5 [ RunTime:0.001989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805721 ORDER BY `minOrder` ASC [ RunTime:0.005353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805721 ORDER BY `unit` DESC [ RunTime:0.003280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805721 LIMIT 2 [ RunTime:0.013929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805721 ORDER BY `minOrder` ASC [ RunTime:0.002032s ]
select * from pdf where partno='1082106' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082106' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000486s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805721 AND `partno` = '1082106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981881 [ RunTime:0.001916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805348 LIMIT 5 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805348 ORDER BY `minOrder` ASC [ RunTime:0.005558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805348 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805348 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805348 ORDER BY `minOrder` ASC [ RunTime:0.008616s ]
select * from pdf where partno='1082134' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082134' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005678s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805348 AND `partno` = '1082134' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773869 [ RunTime:0.002455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802495 LIMIT 5 [ RunTime:0.003716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802495 ORDER BY `minOrder` ASC [ RunTime:0.002089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802495 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802495 LIMIT 2 [ RunTime:0.007112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802495 ORDER BY `minOrder` ASC [ RunTime:0.002113s ]
select * from pdf where partno='1082171' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082171' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000905s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802495 AND `partno` = '1082171' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979968 [ RunTime:0.013072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802425 LIMIT 5 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802425 ORDER BY `minOrder` ASC [ RunTime:0.003354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802425 ORDER BY `unit` DESC [ RunTime:0.007488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802425 LIMIT 2 [ RunTime:0.020665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802425 ORDER BY `minOrder` ASC [ RunTime:0.000949s ]
select * from pdf where partno='1082116' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082116' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003248s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802425 AND `partno` = '1082116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772128 [ RunTime:0.009877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64801184 LIMIT 5 [ RunTime:0.013734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801184 ORDER BY `minOrder` ASC [ RunTime:0.012066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64801184 ORDER BY `unit` DESC [ RunTime:0.002699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64801184 LIMIT 2 [ RunTime:0.015312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801184 ORDER BY `minOrder` ASC [ RunTime:0.015762s ]
select * from pdf where partno='1082195' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082195' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010829s ]
SELECT `id` FROM `stock` WHERE `id` <> 64801184 AND `partno` = '1082195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771339 [ RunTime:0.015898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64780478 LIMIT 5 [ RunTime:0.002306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64780478 ORDER BY `minOrder` ASC [ RunTime:0.013209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64780478 ORDER BY `unit` DESC [ RunTime:0.004379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64780478 LIMIT 2 [ RunTime:0.004234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64780478 ORDER BY `minOrder` ASC [ RunTime:0.001594s ]
select * from pdf where partno='1082174' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082174' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003877s ]
SELECT `id` FROM `stock` WHERE `id` <> 64780478 AND `partno` = '1082174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64247740 LIMIT 5 [ RunTime:0.018948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64247740 ORDER BY `minOrder` ASC [ RunTime:0.026704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64247740 ORDER BY `unit` DESC [ RunTime:0.017197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64247740 LIMIT 2 [ RunTime:0.023449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64247740 ORDER BY `minOrder` ASC [ RunTime:0.011260s ]
select * from pdf where partno='1082129' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.028198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082129' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64247739 LIMIT 5 [ RunTime:0.002367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64247739 ORDER BY `minOrder` ASC [ RunTime:0.005577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64247739 ORDER BY `unit` DESC [ RunTime:0.005330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64247739 LIMIT 2 [ RunTime:0.010458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64247739 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='1082130' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082130' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64178911 LIMIT 5 [ RunTime:0.019562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178911 ORDER BY `minOrder` ASC [ RunTime:0.024242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64178911 ORDER BY `unit` DESC [ RunTime:0.005743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64178911 LIMIT 2 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178911 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='1082193' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082193' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018382s ]
SELECT `id` FROM `stock` WHERE `id` <> 64178911 AND `partno` = '1082193' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13268053 [ RunTime:0.017364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381269 LIMIT 5 [ RunTime:0.002361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381269 ORDER BY `minOrder` ASC [ RunTime:0.003249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381269 ORDER BY `unit` DESC [ RunTime:0.001995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381269 LIMIT 2 [ RunTime:0.004854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381269 ORDER BY `minOrder` ASC [ RunTime:0.003621s ]
select * from pdf where partno='10821F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.029500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10821F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.013704s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381269 AND `partno` = '10821F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.007010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380522 LIMIT 5 [ RunTime:0.017340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380522 ORDER BY `minOrder` ASC [ RunTime:0.001149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380522 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380522 LIMIT 2 [ RunTime:0.001201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380522 ORDER BY `minOrder` ASC [ RunTime:0.005461s ]
select * from pdf where partno='10821' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.005759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10821' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.001330s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380522 AND `partno` = '10821' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347480 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347480 ORDER BY `minOrder` ASC [ RunTime:0.015553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347480 ORDER BY `unit` DESC [ RunTime:0.000801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347480 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347480 ORDER BY `minOrder` ASC [ RunTime:0.000857s ]
select * from pdf where partno='1082137' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082137' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002359s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347480 AND `partno` = '1082137' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011764 [ RunTime:0.010893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345480 LIMIT 5 [ RunTime:0.006336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345480 ORDER BY `minOrder` ASC [ RunTime:0.002814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345480 ORDER BY `unit` DESC [ RunTime:0.002567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345480 LIMIT 2 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345480 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='1082104' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082104' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000458s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345480 AND `partno` = '1082104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780287 [ RunTime:0.000428s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007561s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005459s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008162s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001535s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001571s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001200s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004986s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10821%' OR `brand` LIKE '10821%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001482s ]