SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001824s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.227' , `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=4119&search=1' [ RunTime:0.004891s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001550s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001353s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001791s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.001534s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001583s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002381s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001304s ]
SELECT * FROM `stock_search` WHERE `partno` = '4119' LIMIT 1 [ RunTime:0.022900s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-27 12:14:52' WHERE `partno` = '4119' [ RunTime:0.011685s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001455s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045846s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517007 LIMIT 5 [ RunTime:0.014771s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517007 ORDER BY `minOrder` ASC [ RunTime:0.009843s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517007 ORDER BY `unit` DESC [ RunTime:0.044410s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517007 LIMIT 2 [ RunTime:0.022764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517007 ORDER BY `minOrder` ASC [ RunTime:0.029527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19597329 LIMIT 5 [ RunTime:0.015760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19597329 ORDER BY `minOrder` ASC [ RunTime:0.014949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19597329 ORDER BY `unit` DESC [ RunTime:0.026781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19597329 LIMIT 2 [ RunTime:0.005698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19597329 ORDER BY `minOrder` ASC [ RunTime:0.005008s ]
select * from pdf where partno='4119-0-15-15-47-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.030363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077699 LIMIT 5 [ RunTime:0.054238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077699 ORDER BY `minOrder` ASC [ RunTime:0.046408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077699 ORDER BY `unit` DESC [ RunTime:0.047892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077699 LIMIT 2 [ RunTime:0.011239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077699 ORDER BY `minOrder` ASC [ RunTime:0.006116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18646276 LIMIT 5 [ RunTime:0.049181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18646276 ORDER BY `minOrder` ASC [ RunTime:0.023829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18646276 ORDER BY `unit` DESC [ RunTime:0.020778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18646276 LIMIT 2 [ RunTime:0.008163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18646276 ORDER BY `minOrder` ASC [ RunTime:0.017944s ]
select * from pdf where partno='411910B02500' and brandshort='Comair Rotron' limit 1 [ RunTime:0.044436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15548158 LIMIT 5 [ RunTime:0.023936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548158 ORDER BY `minOrder` ASC [ RunTime:0.026499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15548158 ORDER BY `unit` DESC [ RunTime:0.028703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15548158 LIMIT 2 [ RunTime:0.021601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548158 ORDER BY `minOrder` ASC [ RunTime:0.008859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15548153 LIMIT 5 [ RunTime:0.007695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548153 ORDER BY `minOrder` ASC [ RunTime:0.024680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15548153 ORDER BY `unit` DESC [ RunTime:0.011020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15548153 LIMIT 2 [ RunTime:0.012138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548153 ORDER BY `minOrder` ASC [ RunTime:0.004790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443118 LIMIT 5 [ RunTime:0.003665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443118 ORDER BY `minOrder` ASC [ RunTime:0.022081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443118 ORDER BY `unit` DESC [ RunTime:0.004519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443118 LIMIT 2 [ RunTime:0.001979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443118 ORDER BY `minOrder` ASC [ RunTime:0.009890s ]
select * from pdf where partno='4119-0-15-80-47-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15192591 LIMIT 5 [ RunTime:0.015886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15192591 ORDER BY `minOrder` ASC [ RunTime:0.025605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15192591 ORDER BY `unit` DESC [ RunTime:0.014919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15192591 LIMIT 2 [ RunTime:0.003600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15192591 ORDER BY `minOrder` ASC [ RunTime:0.005492s ]
select * from pdf where partno='411915B02500' and brandshort='Comair Rotron' limit 1 [ RunTime:0.013584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424398 LIMIT 5 [ RunTime:0.034136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424398 ORDER BY `minOrder` ASC [ RunTime:0.011123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14424398 ORDER BY `unit` DESC [ RunTime:0.003376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14424398 LIMIT 2 [ RunTime:0.022570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424398 ORDER BY `minOrder` ASC [ RunTime:0.005065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556783 LIMIT 5 [ RunTime:0.007219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556783 ORDER BY `minOrder` ASC [ RunTime:0.049744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556783 ORDER BY `unit` DESC [ RunTime:0.041158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556783 LIMIT 2 [ RunTime:0.016870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556783 ORDER BY `minOrder` ASC [ RunTime:0.006045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556760 LIMIT 5 [ RunTime:0.037858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556760 ORDER BY `minOrder` ASC [ RunTime:0.009803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556760 ORDER BY `unit` DESC [ RunTime:0.045397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556760 LIMIT 2 [ RunTime:0.072524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556760 ORDER BY `minOrder` ASC [ RunTime:0.057081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555383 LIMIT 5 [ RunTime:0.051545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555383 ORDER BY `minOrder` ASC [ RunTime:0.030789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555383 ORDER BY `unit` DESC [ RunTime:0.076974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555383 LIMIT 2 [ RunTime:0.048291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555383 ORDER BY `minOrder` ASC [ RunTime:0.002353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459771 LIMIT 5 [ RunTime:0.037677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459771 ORDER BY `minOrder` ASC [ RunTime:0.041415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459771 ORDER BY `unit` DESC [ RunTime:0.065291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459771 LIMIT 2 [ RunTime:0.072777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459771 ORDER BY `minOrder` ASC [ RunTime:0.043196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459600 LIMIT 5 [ RunTime:0.051550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459600 ORDER BY `minOrder` ASC [ RunTime:0.047277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459600 ORDER BY `unit` DESC [ RunTime:0.066808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459600 LIMIT 2 [ RunTime:0.041367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459600 ORDER BY `minOrder` ASC [ RunTime:0.013646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459043 LIMIT 5 [ RunTime:0.029708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459043 ORDER BY `minOrder` ASC [ RunTime:0.041156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459043 ORDER BY `unit` DESC [ RunTime:0.039855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459043 LIMIT 2 [ RunTime:0.015763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459043 ORDER BY `minOrder` ASC [ RunTime:0.010783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457565 LIMIT 5 [ RunTime:0.016788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457565 ORDER BY `minOrder` ASC [ RunTime:0.015190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457565 ORDER BY `unit` DESC [ RunTime:0.091281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457565 LIMIT 2 [ RunTime:0.012776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457565 ORDER BY `minOrder` ASC [ RunTime:0.017806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13297147 LIMIT 5 [ RunTime:0.027634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13297147 ORDER BY `minOrder` ASC [ RunTime:0.031185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13297147 ORDER BY `unit` DESC [ RunTime:0.063443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13297147 LIMIT 2 [ RunTime:0.017658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13297147 ORDER BY `minOrder` ASC [ RunTime:0.008469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290226 LIMIT 5 [ RunTime:0.006852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290226 ORDER BY `minOrder` ASC [ RunTime:0.018775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290226 ORDER BY `unit` DESC [ RunTime:0.047082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290226 LIMIT 2 [ RunTime:0.016329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290226 ORDER BY `minOrder` ASC [ RunTime:0.016127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564164 LIMIT 5 [ RunTime:0.021248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564164 ORDER BY `minOrder` ASC [ RunTime:0.019571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12564164 ORDER BY `unit` DESC [ RunTime:0.051498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12564164 LIMIT 2 [ RunTime:0.018417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564164 ORDER BY `minOrder` ASC [ RunTime:0.017671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394283 LIMIT 5 [ RunTime:0.046010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12394283 ORDER BY `minOrder` ASC [ RunTime:0.023962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12394283 ORDER BY `unit` DESC [ RunTime:0.022813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12394283 LIMIT 2 [ RunTime:0.027675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12394283 ORDER BY `minOrder` ASC [ RunTime:0.023141s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280565 LIMIT 5 [ RunTime:0.017515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280565 ORDER BY `minOrder` ASC [ RunTime:0.023799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280565 ORDER BY `unit` DESC [ RunTime:0.036169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280565 LIMIT 2 [ RunTime:0.023430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280565 ORDER BY `minOrder` ASC [ RunTime:0.020109s ]
select * from pdf where partno='4119-0-15-15-47-27-04-0' and brandshort='mill-max' limit 1 [ RunTime:0.015522s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-0-15-15-47-27-04-0' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.043209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51103071 LIMIT 5 [ RunTime:0.021053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51103071 ORDER BY `minOrder` ASC [ RunTime:0.025203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51103071 ORDER BY `unit` DESC [ RunTime:0.007859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51103071 LIMIT 2 [ RunTime:0.029370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51103071 ORDER BY `minOrder` ASC [ RunTime:0.022142s ]
select * from pdf where partno='4119' and brandshort='adafruit' limit 1 [ RunTime:0.027402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.013102s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53819132 LIMIT 5 [ RunTime:0.023202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819132 ORDER BY `minOrder` ASC [ RunTime:0.039804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53819132 ORDER BY `unit` DESC [ RunTime:0.018756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53819132 LIMIT 2 [ RunTime:0.016798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819132 ORDER BY `minOrder` ASC [ RunTime:0.018590s ]
select * from pdf where partno='41194' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41194' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.041082s ]
SELECT `id` FROM `stock` WHERE `id` <> 53819132 AND `partno` = '41194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.043163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517007 [ RunTime:0.029832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53797799 LIMIT 5 [ RunTime:0.048606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53797799 ORDER BY `minOrder` ASC [ RunTime:0.076797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53797799 ORDER BY `unit` DESC [ RunTime:0.056331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53797799 LIMIT 2 [ RunTime:0.071365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53797799 ORDER BY `minOrder` ASC [ RunTime:0.015726s ]
select * from pdf where partno='4119-50' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.046285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-50' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.030270s ]
SELECT `id` FROM `stock` WHERE `id` <> 53797799 AND `partno` = '4119-50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.030550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53496246 LIMIT 5 [ RunTime:0.016893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53496246 ORDER BY `minOrder` ASC [ RunTime:0.020801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53496246 ORDER BY `unit` DESC [ RunTime:0.058679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53496246 LIMIT 2 [ RunTime:0.028090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53496246 ORDER BY `minOrder` ASC [ RunTime:0.015684s ]
select * from pdf where partno='4119-0-15-15-47-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.021643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-0-15-15-47-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.048695s ]
SELECT `id` FROM `stock` WHERE `id` <> 53496246 AND `partno` = '4119-0-15-15-47-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.031350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19597329 [ RunTime:0.024906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714565 LIMIT 5 [ RunTime:0.012487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714565 ORDER BY `minOrder` ASC [ RunTime:0.050522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714565 ORDER BY `unit` DESC [ RunTime:0.010515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714565 LIMIT 2 [ RunTime:0.015735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714565 ORDER BY `minOrder` ASC [ RunTime:0.006587s ]
select * from pdf where partno='41191' and brandshort='Brady Corporation' limit 1 [ RunTime:0.028525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41191' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.014085s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714565 AND `partno` = '41191' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556783 [ RunTime:0.026516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714521 LIMIT 5 [ RunTime:0.028623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714521 ORDER BY `minOrder` ASC [ RunTime:0.026767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714521 ORDER BY `unit` DESC [ RunTime:0.084002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714521 LIMIT 2 [ RunTime:0.058201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714521 ORDER BY `minOrder` ASC [ RunTime:0.018047s ]
select * from pdf where partno='41193' and brandshort='Brady Corporation' limit 1 [ RunTime:0.106408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41193' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.097740s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714521 AND `partno` = '41193' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.083444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556760 [ RunTime:0.018464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57712201 LIMIT 5 [ RunTime:0.039323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712201 ORDER BY `minOrder` ASC [ RunTime:0.049527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57712201 ORDER BY `unit` DESC [ RunTime:0.060775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57712201 LIMIT 2 [ RunTime:0.030913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712201 ORDER BY `minOrder` ASC [ RunTime:0.044113s ]
select * from pdf where partno='41190' and brandshort='Brady Corporation' limit 1 [ RunTime:0.030588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41190' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.036375s ]
SELECT `id` FROM `stock` WHERE `id` <> 57712201 AND `partno` = '41190' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.050588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555383 [ RunTime:0.113327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57712134 LIMIT 5 [ RunTime:0.029560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712134 ORDER BY `minOrder` ASC [ RunTime:0.027423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57712134 ORDER BY `unit` DESC [ RunTime:0.063901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57712134 LIMIT 2 [ RunTime:0.024342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712134 ORDER BY `minOrder` ASC [ RunTime:0.002002s ]
select * from pdf where partno='41192' and brandshort='Brady Corporation' limit 1 [ RunTime:0.033535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41192' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.039651s ]
SELECT `id` FROM `stock` WHERE `id` <> 57712134 AND `partno` = '41192' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.033305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424398 [ RunTime:0.062863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703389 LIMIT 5 [ RunTime:0.058788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703389 ORDER BY `minOrder` ASC [ RunTime:0.024304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703389 ORDER BY `unit` DESC [ RunTime:0.040076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703389 LIMIT 2 [ RunTime:0.022052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703389 ORDER BY `minOrder` ASC [ RunTime:0.031326s ]
select * from pdf where partno='4119-D' and brandshort='Brady Corporation' limit 1 [ RunTime:0.033560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-D' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027635s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703389 AND `partno` = '4119-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.040383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457565 [ RunTime:0.010419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703212 LIMIT 5 [ RunTime:0.001475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703212 ORDER BY `minOrder` ASC [ RunTime:0.045004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703212 ORDER BY `unit` DESC [ RunTime:0.015262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703212 LIMIT 2 [ RunTime:0.049855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703212 ORDER BY `minOrder` ASC [ RunTime:0.006047s ]
select * from pdf where partno='4119-C' and brandshort='Brady Corporation' limit 1 [ RunTime:0.023184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-C' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.034772s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703212 AND `partno` = '4119-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459771 [ RunTime:0.030028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57702926 LIMIT 5 [ RunTime:0.022984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702926 ORDER BY `minOrder` ASC [ RunTime:0.034669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57702926 ORDER BY `unit` DESC [ RunTime:0.049887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57702926 LIMIT 2 [ RunTime:0.030664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702926 ORDER BY `minOrder` ASC [ RunTime:0.015017s ]
select * from pdf where partno='4119-B' and brandshort='Brady Corporation' limit 1 [ RunTime:0.020010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-B' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.025762s ]
SELECT `id` FROM `stock` WHERE `id` <> 57702926 AND `partno` = '4119-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459600 [ RunTime:0.049632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57702748 LIMIT 5 [ RunTime:0.073158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702748 ORDER BY `minOrder` ASC [ RunTime:0.019203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57702748 ORDER BY `unit` DESC [ RunTime:0.023587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57702748 LIMIT 2 [ RunTime:0.036223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702748 ORDER BY `minOrder` ASC [ RunTime:0.004668s ]
select * from pdf where partno='4119-A' and brandshort='Brady Corporation' limit 1 [ RunTime:0.047229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-A' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006375s ]
SELECT `id` FROM `stock` WHERE `id` <> 57702748 AND `partno` = '4119-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.043743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459043 [ RunTime:0.012000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56604332 LIMIT 5 [ RunTime:0.027228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56604332 ORDER BY `minOrder` ASC [ RunTime:0.043337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56604332 ORDER BY `unit` DESC [ RunTime:0.148834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56604332 LIMIT 2 [ RunTime:0.043194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56604332 ORDER BY `minOrder` ASC [ RunTime:0.053045s ]
select * from pdf where partno='4119-BLACK-25-HW-FBA' and brandshort='80/20, LLC' limit 1 [ RunTime:0.051062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-BLACK-25-HW-FBA' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.042850s ]
SELECT `id` FROM `stock` WHERE `id` <> 56604332 AND `partno` = '4119-BLACK-25-HW-FBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.050204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56604202 LIMIT 5 [ RunTime:0.050218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56604202 ORDER BY `minOrder` ASC [ RunTime:0.054654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56604202 ORDER BY `unit` DESC [ RunTime:0.014254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56604202 LIMIT 2 [ RunTime:0.020639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56604202 ORDER BY `minOrder` ASC [ RunTime:0.012291s ]
select * from pdf where partno='4119-25-HW-FBA' and brandshort='80/20, LLC' limit 1 [ RunTime:0.012482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-25-HW-FBA' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.043124s ]
SELECT `id` FROM `stock` WHERE `id` <> 56604202 AND `partno` = '4119-25-HW-FBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.042210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56603859 LIMIT 5 [ RunTime:0.049059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56603859 ORDER BY `minOrder` ASC [ RunTime:0.051711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56603859 ORDER BY `unit` DESC [ RunTime:0.017976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56603859 LIMIT 2 [ RunTime:0.021316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56603859 ORDER BY `minOrder` ASC [ RunTime:0.021324s ]
select * from pdf where partno='4119-BLACK-10-HW-FBA' and brandshort='80/20, LLC' limit 1 [ RunTime:0.026396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-BLACK-10-HW-FBA' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.068789s ]
SELECT `id` FROM `stock` WHERE `id` <> 56603859 AND `partno` = '4119-BLACK-10-HW-FBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.063287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56603615 LIMIT 5 [ RunTime:0.108123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56603615 ORDER BY `minOrder` ASC [ RunTime:0.114474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56603615 ORDER BY `unit` DESC [ RunTime:0.045146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56603615 LIMIT 2 [ RunTime:0.028605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56603615 ORDER BY `minOrder` ASC [ RunTime:0.080461s ]
select * from pdf where partno='4119-10-HW-FBA' and brandshort='80/20, LLC' limit 1 [ RunTime:0.051228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-10-HW-FBA' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.031910s ]
SELECT `id` FROM `stock` WHERE `id` <> 56603615 AND `partno` = '4119-10-HW-FBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.050973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56600886 LIMIT 5 [ RunTime:0.073964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600886 ORDER BY `minOrder` ASC [ RunTime:0.053111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56600886 ORDER BY `unit` DESC [ RunTime:0.108788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56600886 LIMIT 2 [ RunTime:0.044781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600886 ORDER BY `minOrder` ASC [ RunTime:0.010504s ]
select * from pdf where partno='4119-BLACK-HW-M' and brandshort='80/20, LLC' limit 1 [ RunTime:0.036758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-BLACK-HW-M' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.019743s ]
SELECT `id` FROM `stock` WHERE `id` <> 56600886 AND `partno` = '4119-BLACK-HW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.058972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56600529 LIMIT 5 [ RunTime:0.017634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600529 ORDER BY `minOrder` ASC [ RunTime:0.019359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56600529 ORDER BY `unit` DESC [ RunTime:0.022512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56600529 LIMIT 2 [ RunTime:0.016731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600529 ORDER BY `minOrder` ASC [ RunTime:0.009758s ]
select * from pdf where partno='4119-HW-M' and brandshort='80/20, LLC' limit 1 [ RunTime:0.022434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-HW-M' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.020780s ]
SELECT `id` FROM `stock` WHERE `id` <> 56600529 AND `partno` = '4119-HW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.007126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56600310 LIMIT 5 [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600310 ORDER BY `minOrder` ASC [ RunTime:0.006955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56600310 ORDER BY `unit` DESC [ RunTime:0.006686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56600310 LIMIT 2 [ RunTime:0.013623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600310 ORDER BY `minOrder` ASC [ RunTime:0.008605s ]
select * from pdf where partno='4119-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.007622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.001681s ]
SELECT `id` FROM `stock` WHERE `id` <> 56600310 AND `partno` = '4119-BLACK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.015172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56600046 LIMIT 5 [ RunTime:0.017210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600046 ORDER BY `minOrder` ASC [ RunTime:0.005623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56600046 ORDER BY `unit` DESC [ RunTime:0.004649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56600046 LIMIT 2 [ RunTime:0.006793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600046 ORDER BY `minOrder` ASC [ RunTime:0.004337s ]
select * from pdf where partno='4119' and brandshort='80/20, LLC' limit 1 [ RunTime:0.009458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.006104s ]
SELECT `id` FROM `stock` WHERE `id` <> 56600046 AND `partno` = '4119' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.006828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56326919 LIMIT 5 [ RunTime:0.009704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56326919 ORDER BY `minOrder` ASC [ RunTime:0.014327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56326919 ORDER BY `unit` DESC [ RunTime:0.000852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56326919 LIMIT 2 [ RunTime:0.007164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56326919 ORDER BY `minOrder` ASC [ RunTime:0.007052s ]
select * from pdf where partno='4119' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.010607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4119' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.028717s ]
SELECT `id` FROM `stock` WHERE `id` <> 56326919 AND `partno` = '4119' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.009200s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014048s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009766s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008510s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015190s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016630s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008081s ]
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 '4119%' OR `brand` LIKE '4119%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010900s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4119%' OR `brand` LIKE '4119%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005073s ]