SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003652s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004488s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644053 LIMIT 5 [ RunTime:0.005412s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644053 ORDER BY `minOrder` ASC [ RunTime:0.008558s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19644053 ORDER BY `unit` DESC [ RunTime:0.007852s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19644053 LIMIT 2 [ RunTime:0.004415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644053 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642287 LIMIT 5 [ RunTime:0.009724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642287 ORDER BY `minOrder` ASC [ RunTime:0.002942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19642287 ORDER BY `unit` DESC [ RunTime:0.004636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19642287 LIMIT 2 [ RunTime:0.003428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642287 ORDER BY `minOrder` ASC [ RunTime:0.004335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638210 LIMIT 5 [ RunTime:0.004378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638210 ORDER BY `minOrder` ASC [ RunTime:0.003856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638210 ORDER BY `unit` DESC [ RunTime:0.004327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638210 LIMIT 2 [ RunTime:0.003787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638210 ORDER BY `minOrder` ASC [ RunTime:0.008549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632010 LIMIT 5 [ RunTime:0.004769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632010 ORDER BY `minOrder` ASC [ RunTime:0.004409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19632010 ORDER BY `unit` DESC [ RunTime:0.000688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19632010 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632010 ORDER BY `minOrder` ASC [ RunTime:0.002648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19627495 LIMIT 5 [ RunTime:0.000797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19627495 ORDER BY `minOrder` ASC [ RunTime:0.006504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19627495 ORDER BY `unit` DESC [ RunTime:0.007231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19627495 LIMIT 2 [ RunTime:0.004827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19627495 ORDER BY `minOrder` ASC [ RunTime:0.004133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19622117 LIMIT 5 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19622117 ORDER BY `minOrder` ASC [ RunTime:0.003010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19622117 ORDER BY `unit` DESC [ RunTime:0.005115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19622117 LIMIT 2 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19622117 ORDER BY `minOrder` ASC [ RunTime:0.002253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307633 LIMIT 5 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17307633 ORDER BY `minOrder` ASC [ RunTime:0.002859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17307633 ORDER BY `unit` DESC [ RunTime:0.000745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17307633 LIMIT 2 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17307633 ORDER BY `minOrder` ASC [ RunTime:0.009309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17304091 LIMIT 5 [ RunTime:0.004116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17304091 ORDER BY `minOrder` ASC [ RunTime:0.003182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17304091 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17304091 LIMIT 2 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17304091 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424669 LIMIT 5 [ RunTime:0.006734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424669 ORDER BY `minOrder` ASC [ RunTime:0.003124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14424669 ORDER BY `unit` DESC [ RunTime:0.000278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14424669 LIMIT 2 [ RunTime:0.003314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424669 ORDER BY `minOrder` ASC [ RunTime:0.001766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423355 LIMIT 5 [ RunTime:0.001678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423355 ORDER BY `minOrder` ASC [ RunTime:0.002102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14423355 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14423355 LIMIT 2 [ RunTime:0.006614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423355 ORDER BY `minOrder` ASC [ RunTime:0.003180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554804 LIMIT 5 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554804 ORDER BY `minOrder` ASC [ RunTime:0.003594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554804 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554804 LIMIT 2 [ RunTime:0.011436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554804 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552855 LIMIT 5 [ RunTime:0.002957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552855 ORDER BY `minOrder` ASC [ RunTime:0.003549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13552855 ORDER BY `unit` DESC [ RunTime:0.005459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13552855 LIMIT 2 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552855 ORDER BY `minOrder` ASC [ RunTime:0.008346s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006165s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50746238 LIMIT 5 [ RunTime:0.001376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50746238 ORDER BY `minOrder` ASC [ RunTime:0.003888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50746238 ORDER BY `unit` DESC [ RunTime:0.004765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50746238 LIMIT 2 [ RunTime:0.002426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50746238 ORDER BY `minOrder` ASC [ RunTime:0.006117s ]
select * from pdf where partno='12904' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.004776s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12904' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.014738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38151331 LIMIT 5 [ RunTime:0.001707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38151331 ORDER BY `minOrder` ASC [ RunTime:0.008816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38151331 ORDER BY `unit` DESC [ RunTime:0.006243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38151331 LIMIT 2 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38151331 ORDER BY `minOrder` ASC [ RunTime:0.003037s ]
select * from pdf where partno='12904' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.003905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12904' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.007173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53717733 LIMIT 5 [ RunTime:0.002372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53717733 ORDER BY `minOrder` ASC [ RunTime:0.000947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53717733 ORDER BY `unit` DESC [ RunTime:0.004085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53717733 LIMIT 2 [ RunTime:0.001563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53717733 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
select * from pdf where partno='1290490000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290490000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003941s ]
SELECT `id` FROM `stock` WHERE `id` <> 53717733 AND `partno` = '1290490000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644053 [ RunTime:0.003280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53715470 LIMIT 5 [ RunTime:0.001814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53715470 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53715470 ORDER BY `unit` DESC [ RunTime:0.002988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53715470 LIMIT 2 [ RunTime:0.002623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53715470 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
select * from pdf where partno='1290480000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290480000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001448s ]
SELECT `id` FROM `stock` WHERE `id` <> 53715470 AND `partno` = '1290480000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642287 [ RunTime:0.003162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53712845 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712845 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53712845 ORDER BY `unit` DESC [ RunTime:0.003344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53712845 LIMIT 2 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712845 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
select * from pdf where partno='1290470000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290470000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001827s ]
SELECT `id` FROM `stock` WHERE `id` <> 53712845 AND `partno` = '1290470000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53709643 LIMIT 5 [ RunTime:0.000997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709643 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53709643 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53709643 LIMIT 2 [ RunTime:0.007026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709643 ORDER BY `minOrder` ASC [ RunTime:0.001103s ]
select * from pdf where partno='1290460000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290460000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006198s ]
SELECT `id` FROM `stock` WHERE `id` <> 53709643 AND `partno` = '1290460000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638210 [ RunTime:0.000685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53705456 LIMIT 5 [ RunTime:0.006677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53705456 ORDER BY `minOrder` ASC [ RunTime:0.002494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53705456 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53705456 LIMIT 2 [ RunTime:0.003405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53705456 ORDER BY `minOrder` ASC [ RunTime:0.006776s ]
select * from pdf where partno='1290450000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290450000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003522s ]
SELECT `id` FROM `stock` WHERE `id` <> 53705456 AND `partno` = '1290450000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307633 [ RunTime:0.000672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53700547 LIMIT 5 [ RunTime:0.003609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53700547 ORDER BY `minOrder` ASC [ RunTime:0.010937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53700547 ORDER BY `unit` DESC [ RunTime:0.001971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53700547 LIMIT 2 [ RunTime:0.010046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53700547 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='1290440000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290440000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009061s ]
SELECT `id` FROM `stock` WHERE `id` <> 53700547 AND `partno` = '1290440000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632010 [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53694961 LIMIT 5 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53694961 ORDER BY `minOrder` ASC [ RunTime:0.013316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53694961 ORDER BY `unit` DESC [ RunTime:0.001247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53694961 LIMIT 2 [ RunTime:0.010232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53694961 ORDER BY `minOrder` ASC [ RunTime:0.008547s ]
select * from pdf where partno='1290430000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290430000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004841s ]
SELECT `id` FROM `stock` WHERE `id` <> 53694961 AND `partno` = '1290430000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19627495 [ RunTime:0.000945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53689089 LIMIT 5 [ RunTime:0.007720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53689089 ORDER BY `minOrder` ASC [ RunTime:0.003042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53689089 ORDER BY `unit` DESC [ RunTime:0.007697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53689089 LIMIT 2 [ RunTime:0.003185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53689089 ORDER BY `minOrder` ASC [ RunTime:0.005428s ]
select * from pdf where partno='1290420000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290420000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003971s ]
SELECT `id` FROM `stock` WHERE `id` <> 53689089 AND `partno` = '1290420000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19622117 [ RunTime:0.000749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53682983 LIMIT 5 [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53682983 ORDER BY `minOrder` ASC [ RunTime:0.001281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53682983 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53682983 LIMIT 2 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53682983 ORDER BY `minOrder` ASC [ RunTime:0.010522s ]
select * from pdf where partno='1290410000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1290410000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008517s ]
SELECT `id` FROM `stock` WHERE `id` <> 53682983 AND `partno` = '1290410000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17304091 [ RunTime:0.000835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50711113 LIMIT 5 [ RunTime:0.000868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711113 ORDER BY `minOrder` ASC [ RunTime:0.001222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50711113 ORDER BY `unit` DESC [ RunTime:0.000745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50711113 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711113 ORDER BY `minOrder` ASC [ RunTime:0.010011s ]
select * from pdf where partno='129048' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '129048' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007830s ]
SELECT `id` FROM `stock` WHERE `id` <> 50711113 AND `partno` = '129048' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.009264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424669 [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50709761 LIMIT 5 [ RunTime:0.004462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50709761 ORDER BY `minOrder` ASC [ RunTime:0.002092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50709761 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50709761 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50709761 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
select * from pdf where partno='129040' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '129040' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000489s ]
SELECT `id` FROM `stock` WHERE `id` <> 50709761 AND `partno` = '129040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554804 [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50708316 LIMIT 5 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50708316 ORDER BY `minOrder` ASC [ RunTime:0.002323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50708316 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50708316 LIMIT 2 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50708316 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
select * from pdf where partno='129041' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '129041' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000867s ]
SELECT `id` FROM `stock` WHERE `id` <> 50708316 AND `partno` = '129041' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423355 [ RunTime:0.000674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50706713 LIMIT 5 [ RunTime:0.007926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50706713 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50706713 ORDER BY `unit` DESC [ RunTime:0.000646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50706713 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50706713 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
select * from pdf where partno='129049' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '129049' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001937s ]
SELECT `id` FROM `stock` WHERE `id` <> 50706713 AND `partno` = '129049' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552855 [ RunTime:0.000589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38099171 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38099171 ORDER BY `minOrder` ASC [ RunTime:0.003616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38099171 ORDER BY `unit` DESC [ RunTime:0.000550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38099171 LIMIT 2 [ RunTime:0.005125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38099171 ORDER BY `minOrder` ASC [ RunTime:0.001063s ]
select * from pdf where partno='129048' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '129048' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 38099171 AND `partno` = '129048' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424669 [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38097019 LIMIT 5 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38097019 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38097019 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38097019 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38097019 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='129040' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '129040' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000398s ]
SELECT `id` FROM `stock` WHERE `id` <> 38097019 AND `partno` = '129040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554804 [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38094674 LIMIT 5 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38094674 ORDER BY `minOrder` ASC [ RunTime:0.000927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38094674 ORDER BY `unit` DESC [ RunTime:0.001726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38094674 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38094674 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
select * from pdf where partno='129041' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '129041' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000291s ]
SELECT `id` FROM `stock` WHERE `id` <> 38094674 AND `partno` = '129041' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423355 [ RunTime:0.000270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38092262 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38092262 ORDER BY `minOrder` ASC [ RunTime:0.000808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38092262 ORDER BY `unit` DESC [ RunTime:0.000967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38092262 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38092262 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='129049' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '129049' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000280s ]
SELECT `id` FROM `stock` WHERE `id` <> 38092262 AND `partno` = '129049' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552855 [ RunTime:0.000269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32571680 LIMIT 5 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32571680 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32571680 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32571680 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32571680 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
select * from pdf where partno='12904001' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12904001' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000356s ]
SELECT `id` FROM `stock` WHERE `id` <> 32571680 AND `partno` = '12904001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000593s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000770s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000655s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000653s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000639s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000627s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000647s ]
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 '12904%' OR `brand` LIKE '12904%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000707s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12904%' OR `brand` LIKE '12904%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000705s ]