SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002198s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=4153&search=1' [ RunTime:0.003044s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002071s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004604s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002927s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.013665s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001946s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003480s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001832s ]
SELECT * FROM `stock_search` WHERE `partno` = '4153' LIMIT 1 [ RunTime:0.006578s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-28 14:46:05' WHERE `partno` = '4153' [ RunTime:0.015694s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003057s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019845s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418211 LIMIT 5 [ RunTime:0.049761s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418211 ORDER BY `minOrder` ASC [ RunTime:0.007332s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418211 ORDER BY `unit` DESC [ RunTime:0.015084s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418211 LIMIT 2 [ RunTime:0.014291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418211 ORDER BY `minOrder` ASC [ RunTime:0.011127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518924 LIMIT 5 [ RunTime:0.037253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518924 ORDER BY `minOrder` ASC [ RunTime:0.025694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12518924 ORDER BY `unit` DESC [ RunTime:0.016394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12518924 LIMIT 2 [ RunTime:0.035818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518924 ORDER BY `minOrder` ASC [ RunTime:0.002259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408409 LIMIT 5 [ RunTime:0.008643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408409 ORDER BY `minOrder` ASC [ RunTime:0.018032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408409 ORDER BY `unit` DESC [ RunTime:0.019154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408409 LIMIT 2 [ RunTime:0.006187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408409 ORDER BY `minOrder` ASC [ RunTime:0.013153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408414 LIMIT 5 [ RunTime:0.007293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408414 ORDER BY `minOrder` ASC [ RunTime:0.014807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408414 ORDER BY `unit` DESC [ RunTime:0.029575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408414 LIMIT 2 [ RunTime:0.049647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408414 ORDER BY `minOrder` ASC [ RunTime:0.010230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352016 LIMIT 5 [ RunTime:0.016935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352016 ORDER BY `minOrder` ASC [ RunTime:0.003945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352016 ORDER BY `unit` DESC [ RunTime:0.056330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352016 LIMIT 2 [ RunTime:0.027542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352016 ORDER BY `minOrder` ASC [ RunTime:0.013819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509928 LIMIT 5 [ RunTime:0.034272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509928 ORDER BY `minOrder` ASC [ RunTime:0.031018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509928 ORDER BY `unit` DESC [ RunTime:0.019266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509928 LIMIT 2 [ RunTime:0.015998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509928 ORDER BY `minOrder` ASC [ RunTime:0.024934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19005807 LIMIT 5 [ RunTime:0.016564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19005807 ORDER BY `minOrder` ASC [ RunTime:0.010297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19005807 ORDER BY `unit` DESC [ RunTime:0.020080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19005807 LIMIT 2 [ RunTime:0.017996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19005807 ORDER BY `minOrder` ASC [ RunTime:0.004002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396897 LIMIT 5 [ RunTime:0.031409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396897 ORDER BY `minOrder` ASC [ RunTime:0.029974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396897 ORDER BY `unit` DESC [ RunTime:0.007200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396897 LIMIT 2 [ RunTime:0.020647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396897 ORDER BY `minOrder` ASC [ RunTime:0.016539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396896 LIMIT 5 [ RunTime:0.004099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396896 ORDER BY `minOrder` ASC [ RunTime:0.005624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396896 ORDER BY `unit` DESC [ RunTime:0.021754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396896 LIMIT 2 [ RunTime:0.032143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396896 ORDER BY `minOrder` ASC [ RunTime:0.007483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396895 LIMIT 5 [ RunTime:0.024274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396895 ORDER BY `minOrder` ASC [ RunTime:0.036177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396895 ORDER BY `unit` DESC [ RunTime:0.037480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396895 LIMIT 2 [ RunTime:0.026408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396895 ORDER BY `minOrder` ASC [ RunTime:0.007332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396894 LIMIT 5 [ RunTime:0.034135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396894 ORDER BY `minOrder` ASC [ RunTime:0.034867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396894 ORDER BY `unit` DESC [ RunTime:0.010251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396894 LIMIT 2 [ RunTime:0.010825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396894 ORDER BY `minOrder` ASC [ RunTime:0.009875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526077 LIMIT 5 [ RunTime:0.019409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526077 ORDER BY `minOrder` ASC [ RunTime:0.003777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13526077 ORDER BY `unit` DESC [ RunTime:0.018560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13526077 LIMIT 2 [ RunTime:0.005074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526077 ORDER BY `minOrder` ASC [ RunTime:0.006388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526075 LIMIT 5 [ RunTime:0.016678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526075 ORDER BY `minOrder` ASC [ RunTime:0.020394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13526075 ORDER BY `unit` DESC [ RunTime:0.005162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13526075 LIMIT 2 [ RunTime:0.009679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526075 ORDER BY `minOrder` ASC [ RunTime:0.010110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526074 LIMIT 5 [ RunTime:0.034985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526074 ORDER BY `minOrder` ASC [ RunTime:0.028823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13526074 ORDER BY `unit` DESC [ RunTime:0.025477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13526074 LIMIT 2 [ RunTime:0.019598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526074 ORDER BY `minOrder` ASC [ RunTime:0.018042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459739 LIMIT 5 [ RunTime:0.011185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459739 ORDER BY `minOrder` ASC [ RunTime:0.010919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459739 ORDER BY `unit` DESC [ RunTime:0.011813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459739 LIMIT 2 [ RunTime:0.007864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459739 ORDER BY `minOrder` ASC [ RunTime:0.003571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459576 LIMIT 5 [ RunTime:0.004248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459576 ORDER BY `minOrder` ASC [ RunTime:0.006121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459576 ORDER BY `unit` DESC [ RunTime:0.019973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459576 LIMIT 2 [ RunTime:0.010187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459576 ORDER BY `minOrder` ASC [ RunTime:0.011569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458314 LIMIT 5 [ RunTime:0.013761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458314 ORDER BY `minOrder` ASC [ RunTime:0.010350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13458314 ORDER BY `unit` DESC [ RunTime:0.002531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13458314 LIMIT 2 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458314 ORDER BY `minOrder` ASC [ RunTime:0.004395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457968 LIMIT 5 [ RunTime:0.010549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457968 ORDER BY `minOrder` ASC [ RunTime:0.016276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457968 ORDER BY `unit` DESC [ RunTime:0.014364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457968 LIMIT 2 [ RunTime:0.017522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457968 ORDER BY `minOrder` ASC [ RunTime:0.003479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457519 LIMIT 5 [ RunTime:0.009914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457519 ORDER BY `minOrder` ASC [ RunTime:0.001696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457519 ORDER BY `unit` DESC [ RunTime:0.015724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457519 LIMIT 2 [ RunTime:0.023599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457519 ORDER BY `minOrder` ASC [ RunTime:0.002347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457518 LIMIT 5 [ RunTime:0.006718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457518 ORDER BY `minOrder` ASC [ RunTime:0.014934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457518 ORDER BY `unit` DESC [ RunTime:0.002605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457518 LIMIT 2 [ RunTime:0.002221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457518 ORDER BY `minOrder` ASC [ RunTime:0.005010s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282095 LIMIT 5 [ RunTime:0.016607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282095 ORDER BY `minOrder` ASC [ RunTime:0.012328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282095 ORDER BY `unit` DESC [ RunTime:0.020643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282095 LIMIT 2 [ RunTime:0.027974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282095 ORDER BY `minOrder` ASC [ RunTime:0.021022s ]
select * from pdf where partno='41531' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.021822s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41531' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.008158s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282095 AND `partno` = '41531' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.024524s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53817680 LIMIT 5 [ RunTime:0.020174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817680 ORDER BY `minOrder` ASC [ RunTime:0.020804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53817680 ORDER BY `unit` DESC [ RunTime:0.043084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53817680 LIMIT 2 [ RunTime:0.010468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817680 ORDER BY `minOrder` ASC [ RunTime:0.012575s ]
select * from pdf where partno='41532' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41532' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.064571s ]
SELECT `id` FROM `stock` WHERE `id` <> 53817680 AND `partno` = '41532' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.014202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418211 [ RunTime:0.017255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53817526 LIMIT 5 [ RunTime:0.001443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817526 ORDER BY `minOrder` ASC [ RunTime:0.004111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53817526 ORDER BY `unit` DESC [ RunTime:0.002233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53817526 LIMIT 2 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817526 ORDER BY `minOrder` ASC [ RunTime:0.001716s ]
select * from pdf where partno='41531' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41531' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004590s ]
SELECT `id` FROM `stock` WHERE `id` <> 53817526 AND `partno` = '41531' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53818416 LIMIT 5 [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818416 ORDER BY `minOrder` ASC [ RunTime:0.003851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53818416 ORDER BY `unit` DESC [ RunTime:0.018984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53818416 LIMIT 2 [ RunTime:0.017521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818416 ORDER BY `minOrder` ASC [ RunTime:0.005868s ]
select * from pdf where partno='41531-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.035953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41531-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.036327s ]
SELECT `id` FROM `stock` WHERE `id` <> 53818416 AND `partno` = '41531-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518924 [ RunTime:0.036644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56312631 LIMIT 5 [ RunTime:0.048587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56312631 ORDER BY `minOrder` ASC [ RunTime:0.031435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56312631 ORDER BY `unit` DESC [ RunTime:0.019579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56312631 LIMIT 2 [ RunTime:0.037960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56312631 ORDER BY `minOrder` ASC [ RunTime:0.021090s ]
select * from pdf where partno='4153F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.013628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.012153s ]
SELECT `id` FROM `stock` WHERE `id` <> 56312631 AND `partno` = '4153F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.007077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408414 [ RunTime:0.044663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56312587 LIMIT 5 [ RunTime:0.031960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56312587 ORDER BY `minOrder` ASC [ RunTime:0.025990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56312587 ORDER BY `unit` DESC [ RunTime:0.033062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56312587 LIMIT 2 [ RunTime:0.013710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56312587 ORDER BY `minOrder` ASC [ RunTime:0.007136s ]
select * from pdf where partno='4153B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.036382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.012134s ]
SELECT `id` FROM `stock` WHERE `id` <> 56312587 AND `partno` = '4153B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.031718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408409 [ RunTime:0.029089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57744064 LIMIT 5 [ RunTime:0.030208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57744064 ORDER BY `minOrder` ASC [ RunTime:0.017783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57744064 ORDER BY `unit` DESC [ RunTime:0.010584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57744064 LIMIT 2 [ RunTime:0.018037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57744064 ORDER BY `minOrder` ASC [ RunTime:0.006954s ]
select * from pdf where partno='4153CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004255s ]
SELECT `id` FROM `stock` WHERE `id` <> 57744064 AND `partno` = '4153CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352016 [ RunTime:0.037070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238289 LIMIT 5 [ RunTime:0.022191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238289 ORDER BY `minOrder` ASC [ RunTime:0.004803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238289 ORDER BY `unit` DESC [ RunTime:0.006105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238289 LIMIT 2 [ RunTime:0.013044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238289 ORDER BY `minOrder` ASC [ RunTime:0.008497s ]
select * from pdf where partno='4153' and brandshort='Pololu' limit 1 [ RunTime:0.015041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.011548s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238289 AND `partno` = '4153' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.017964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509928 [ RunTime:0.013828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57692917 LIMIT 5 [ RunTime:0.013976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57692917 ORDER BY `minOrder` ASC [ RunTime:0.009709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57692917 ORDER BY `unit` DESC [ RunTime:0.015285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57692917 LIMIT 2 [ RunTime:0.016074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57692917 ORDER BY `minOrder` ASC [ RunTime:0.012993s ]
select * from pdf where partno='41532' and brandshort='Brady Corporation' limit 1 [ RunTime:0.028094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41532' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.019617s ]
SELECT `id` FROM `stock` WHERE `id` <> 57692917 AND `partno` = '41532' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396897 [ RunTime:0.035711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57704048 LIMIT 5 [ RunTime:0.016607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57704048 ORDER BY `minOrder` ASC [ RunTime:0.023164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57704048 ORDER BY `unit` DESC [ RunTime:0.027359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57704048 LIMIT 2 [ RunTime:0.017490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57704048 ORDER BY `minOrder` ASC [ RunTime:0.015734s ]
select * from pdf where partno='4153-H' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153-H' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005733s ]
SELECT `id` FROM `stock` WHERE `id` <> 57704048 AND `partno` = '4153-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.021638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457968 [ RunTime:0.014519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703520 LIMIT 5 [ RunTime:0.047318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703520 ORDER BY `minOrder` ASC [ RunTime:0.008541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703520 ORDER BY `unit` DESC [ RunTime:0.010758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703520 LIMIT 2 [ RunTime:0.048045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703520 ORDER BY `minOrder` ASC [ RunTime:0.011054s ]
select * from pdf where partno='4153-F' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153-F' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.033305s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703520 AND `partno` = '4153-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.016440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457518 [ RunTime:0.000851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703376 LIMIT 5 [ RunTime:0.016284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703376 ORDER BY `minOrder` ASC [ RunTime:0.009879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703376 ORDER BY `unit` DESC [ RunTime:0.017226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703376 LIMIT 2 [ RunTime:0.014985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703376 ORDER BY `minOrder` ASC [ RunTime:0.013619s ]
select * from pdf where partno='4153-D' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153-D' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007099s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703376 AND `partno` = '4153-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457519 [ RunTime:0.049950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703190 LIMIT 5 [ RunTime:0.011712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703190 ORDER BY `minOrder` ASC [ RunTime:0.029016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703190 ORDER BY `unit` DESC [ RunTime:0.003397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703190 LIMIT 2 [ RunTime:0.034754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703190 ORDER BY `minOrder` ASC [ RunTime:0.007365s ]
select * from pdf where partno='4153-C' and brandshort='Brady Corporation' limit 1 [ RunTime:0.020415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153-C' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.049902s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703190 AND `partno` = '4153-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.051410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459739 [ RunTime:0.014007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57702909 LIMIT 5 [ RunTime:0.011657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702909 ORDER BY `minOrder` ASC [ RunTime:0.015820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57702909 ORDER BY `unit` DESC [ RunTime:0.009587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57702909 LIMIT 2 [ RunTime:0.033203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702909 ORDER BY `minOrder` ASC [ RunTime:0.011625s ]
select * from pdf where partno='4153-B' and brandshort='Brady Corporation' limit 1 [ RunTime:0.017470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153-B' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006160s ]
SELECT `id` FROM `stock` WHERE `id` <> 57702909 AND `partno` = '4153-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.021953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459576 [ RunTime:0.022257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57702715 LIMIT 5 [ RunTime:0.044826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702715 ORDER BY `minOrder` ASC [ RunTime:0.012473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57702715 ORDER BY `unit` DESC [ RunTime:0.010472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57702715 LIMIT 2 [ RunTime:0.013302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702715 ORDER BY `minOrder` ASC [ RunTime:0.023829s ]
select * from pdf where partno='4153-A' and brandshort='Brady Corporation' limit 1 [ RunTime:0.015892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4153-A' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.018470s ]
SELECT `id` FROM `stock` WHERE `id` <> 57702715 AND `partno` = '4153-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458314 [ RunTime:0.002689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57700806 LIMIT 5 [ RunTime:0.004506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700806 ORDER BY `minOrder` ASC [ RunTime:0.005382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57700806 ORDER BY `unit` DESC [ RunTime:0.003266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57700806 LIMIT 2 [ RunTime:0.010635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700806 ORDER BY `minOrder` ASC [ RunTime:0.008040s ]
select * from pdf where partno='41539' and brandshort='Brady Corporation' limit 1 [ RunTime:0.018867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41539' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017175s ]
SELECT `id` FROM `stock` WHERE `id` <> 57700806 AND `partno` = '41539' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.027379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396896 [ RunTime:0.017007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57700805 LIMIT 5 [ RunTime:0.026624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700805 ORDER BY `minOrder` ASC [ RunTime:0.031175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57700805 ORDER BY `unit` DESC [ RunTime:0.020176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57700805 LIMIT 2 [ RunTime:0.010469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700805 ORDER BY `minOrder` ASC [ RunTime:0.012092s ]
select * from pdf where partno='41536' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41536' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.029258s ]
SELECT `id` FROM `stock` WHERE `id` <> 57700805 AND `partno` = '41536' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.024678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396895 [ RunTime:0.002044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57700804 LIMIT 5 [ RunTime:0.002327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700804 ORDER BY `minOrder` ASC [ RunTime:0.026122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57700804 ORDER BY `unit` DESC [ RunTime:0.015906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57700804 LIMIT 2 [ RunTime:0.029306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700804 ORDER BY `minOrder` ASC [ RunTime:0.008310s ]
select * from pdf where partno='41535' and brandshort='Brady Corporation' limit 1 [ RunTime:0.011474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41535' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020497s ]
SELECT `id` FROM `stock` WHERE `id` <> 57700804 AND `partno` = '41535' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.015814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396894 [ RunTime:0.010417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57700801 LIMIT 5 [ RunTime:0.009452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700801 ORDER BY `minOrder` ASC [ RunTime:0.016187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57700801 ORDER BY `unit` DESC [ RunTime:0.009774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57700801 LIMIT 2 [ RunTime:0.020499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700801 ORDER BY `minOrder` ASC [ RunTime:0.012304s ]
select * from pdf where partno='41538' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41538' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016209s ]
SELECT `id` FROM `stock` WHERE `id` <> 57700801 AND `partno` = '41538' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.024874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526077 [ RunTime:0.002835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57700799 LIMIT 5 [ RunTime:0.012228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700799 ORDER BY `minOrder` ASC [ RunTime:0.015382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57700799 ORDER BY `unit` DESC [ RunTime:0.009017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57700799 LIMIT 2 [ RunTime:0.004358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700799 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='41537' and brandshort='Brady Corporation' limit 1 [ RunTime:0.013705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41537' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.035877s ]
SELECT `id` FROM `stock` WHERE `id` <> 57700799 AND `partno` = '41537' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526075 [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57700798 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700798 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57700798 ORDER BY `unit` DESC [ RunTime:0.003054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57700798 LIMIT 2 [ RunTime:0.003917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700798 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='41530' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41530' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004524s ]
SELECT `id` FROM `stock` WHERE `id` <> 57700798 AND `partno` = '41530' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.026178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526074 [ RunTime:0.012387s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015521s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004882s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002920s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016542s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014383s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010235s ]
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 '4153%' OR `brand` LIKE '4153%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006169s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4153%' OR `brand` LIKE '4153%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007995s ]