SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002258s ]
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=4103&search=1' [ RunTime:0.006143s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002107s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002473s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001352s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000212s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001529s ]
SELECT * FROM `stock_search` WHERE `partno` = '4103' LIMIT 1 [ RunTime:0.002257s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-28 14:46:05' WHERE `partno` = '4103' [ RunTime:0.002993s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001704s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015641s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347689 LIMIT 5 [ RunTime:0.027569s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347689 ORDER BY `minOrder` ASC [ RunTime:0.002278s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13347689 ORDER BY `unit` DESC [ RunTime:0.005187s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13347689 LIMIT 2 [ RunTime:0.008146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347689 ORDER BY `minOrder` ASC [ RunTime:0.005238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17264343 LIMIT 5 [ RunTime:0.008974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17264343 ORDER BY `minOrder` ASC [ RunTime:0.008427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17264343 ORDER BY `unit` DESC [ RunTime:0.021471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17264343 LIMIT 2 [ RunTime:0.030552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17264343 ORDER BY `minOrder` ASC [ RunTime:0.018075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425436 LIMIT 5 [ RunTime:0.016603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425436 ORDER BY `minOrder` ASC [ RunTime:0.012654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425436 ORDER BY `unit` DESC [ RunTime:0.015479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425436 LIMIT 2 [ RunTime:0.006125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425436 ORDER BY `minOrder` ASC [ RunTime:0.034727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425414 LIMIT 5 [ RunTime:0.015095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425414 ORDER BY `minOrder` ASC [ RunTime:0.030489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425414 ORDER BY `unit` DESC [ RunTime:0.017632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425414 LIMIT 2 [ RunTime:0.019993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425414 ORDER BY `minOrder` ASC [ RunTime:0.018791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425413 LIMIT 5 [ RunTime:0.001894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425413 ORDER BY `minOrder` ASC [ RunTime:0.011693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425413 ORDER BY `unit` DESC [ RunTime:0.024323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425413 LIMIT 2 [ RunTime:0.015493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425413 ORDER BY `minOrder` ASC [ RunTime:0.012530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425408 LIMIT 5 [ RunTime:0.009688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425408 ORDER BY `minOrder` ASC [ RunTime:0.015438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425408 ORDER BY `unit` DESC [ RunTime:0.036241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425408 LIMIT 2 [ RunTime:0.049049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425408 ORDER BY `minOrder` ASC [ RunTime:0.007114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425398 LIMIT 5 [ RunTime:0.017257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425398 ORDER BY `minOrder` ASC [ RunTime:0.032067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425398 ORDER BY `unit` DESC [ RunTime:0.007878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425398 LIMIT 2 [ RunTime:0.047873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425398 ORDER BY `minOrder` ASC [ RunTime:0.009521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345574 LIMIT 5 [ RunTime:0.019662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345574 ORDER BY `minOrder` ASC [ RunTime:0.025221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345574 ORDER BY `unit` DESC [ RunTime:0.023364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345574 LIMIT 2 [ RunTime:0.008370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345574 ORDER BY `minOrder` ASC [ RunTime:0.013788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345445 LIMIT 5 [ RunTime:0.013438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345445 ORDER BY `minOrder` ASC [ RunTime:0.008754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345445 ORDER BY `unit` DESC [ RunTime:0.022975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345445 LIMIT 2 [ RunTime:0.006712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345445 ORDER BY `minOrder` ASC [ RunTime:0.009059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556504 LIMIT 5 [ RunTime:0.006801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556504 ORDER BY `minOrder` ASC [ RunTime:0.022064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556504 ORDER BY `unit` DESC [ RunTime:0.002078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556504 LIMIT 2 [ RunTime:0.007262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556504 ORDER BY `minOrder` ASC [ RunTime:0.014458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556497 LIMIT 5 [ RunTime:0.030066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556497 ORDER BY `minOrder` ASC [ RunTime:0.004157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556497 ORDER BY `unit` DESC [ RunTime:0.030136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556497 LIMIT 2 [ RunTime:0.012777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556497 ORDER BY `minOrder` ASC [ RunTime:0.001880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556486 LIMIT 5 [ RunTime:0.022851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556486 ORDER BY `minOrder` ASC [ RunTime:0.008324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556486 ORDER BY `unit` DESC [ RunTime:0.014221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556486 LIMIT 2 [ RunTime:0.012952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556486 ORDER BY `minOrder` ASC [ RunTime:0.006564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556477 LIMIT 5 [ RunTime:0.028659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556477 ORDER BY `minOrder` ASC [ RunTime:0.013597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556477 ORDER BY `unit` DESC [ RunTime:0.052194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556477 LIMIT 2 [ RunTime:0.053994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556477 ORDER BY `minOrder` ASC [ RunTime:0.011930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459915 LIMIT 5 [ RunTime:0.010821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459915 ORDER BY `minOrder` ASC [ RunTime:0.045233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459915 ORDER BY `unit` DESC [ RunTime:0.025916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459915 LIMIT 2 [ RunTime:0.023469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459915 ORDER BY `minOrder` ASC [ RunTime:0.009911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459729 LIMIT 5 [ RunTime:0.019176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459729 ORDER BY `minOrder` ASC [ RunTime:0.003179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459729 ORDER BY `unit` DESC [ RunTime:0.020023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459729 LIMIT 2 [ RunTime:0.015006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459729 ORDER BY `minOrder` ASC [ RunTime:0.013168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458296 LIMIT 5 [ RunTime:0.020629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458296 ORDER BY `minOrder` ASC [ RunTime:0.014113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13458296 ORDER BY `unit` DESC [ RunTime:0.029853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13458296 LIMIT 2 [ RunTime:0.027243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458296 ORDER BY `minOrder` ASC [ RunTime:0.001563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457963 LIMIT 5 [ RunTime:0.038077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457963 ORDER BY `minOrder` ASC [ RunTime:0.022308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457963 ORDER BY `unit` DESC [ RunTime:0.029161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457963 LIMIT 2 [ RunTime:0.011724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457963 ORDER BY `minOrder` ASC [ RunTime:0.009428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13340898 LIMIT 5 [ RunTime:0.006428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13340898 ORDER BY `minOrder` ASC [ RunTime:0.007413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13340898 ORDER BY `unit` DESC [ RunTime:0.002969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13340898 LIMIT 2 [ RunTime:0.012876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13340898 ORDER BY `minOrder` ASC [ RunTime:0.015349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13295894 LIMIT 5 [ RunTime:0.016083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13295894 ORDER BY `minOrder` ASC [ RunTime:0.003584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13295894 ORDER BY `unit` DESC [ RunTime:0.017534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13295894 LIMIT 2 [ RunTime:0.002205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13295894 ORDER BY `minOrder` ASC [ RunTime:0.001613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293792 LIMIT 5 [ RunTime:0.000992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293792 ORDER BY `minOrder` ASC [ RunTime:0.010159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13293792 ORDER BY `unit` DESC [ RunTime:0.019718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13293792 LIMIT 2 [ RunTime:0.017574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293792 ORDER BY `minOrder` ASC [ RunTime:0.013734s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287470 LIMIT 5 [ RunTime:0.007303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287470 ORDER BY `minOrder` ASC [ RunTime:0.011385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287470 ORDER BY `unit` DESC [ RunTime:0.014933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287470 LIMIT 2 [ RunTime:0.012804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287470 ORDER BY `minOrder` ASC [ RunTime:0.009012s ]
select * from pdf where partno='4103g' and brandshort='aavid' limit 1 [ RunTime:0.017093s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103g' OR `brand` LIKE 'aavid%' ) ) LIMIT 1 [ RunTime:0.009936s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287470 AND `partno` = '4103g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aavid%' ) [ RunTime:0.009425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095453 LIMIT 5 [ RunTime:0.016900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095453 ORDER BY `minOrder` ASC [ RunTime:0.004802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095453 ORDER BY `unit` DESC [ RunTime:0.012716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095453 LIMIT 2 [ RunTime:0.033948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095453 ORDER BY `minOrder` ASC [ RunTime:0.011946s ]
select * from pdf where partno='4103' and brandshort='adafruit' limit 1 [ RunTime:0.031046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.023892s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51645777 LIMIT 5 [ RunTime:0.005619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51645777 ORDER BY `minOrder` ASC [ RunTime:0.024898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51645777 ORDER BY `unit` DESC [ RunTime:0.041333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51645777 LIMIT 2 [ RunTime:0.038685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51645777 ORDER BY `minOrder` ASC [ RunTime:0.002776s ]
select * from pdf where partno='4103000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.019332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.040659s ]
SELECT `id` FROM `stock` WHERE `id` <> 51645777 AND `partno` = '4103000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.023251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57737657 LIMIT 5 [ RunTime:0.010585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737657 ORDER BY `minOrder` ASC [ RunTime:0.014401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57737657 ORDER BY `unit` DESC [ RunTime:0.002431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57737657 LIMIT 2 [ RunTime:0.006426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737657 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
select * from pdf where partno='4103CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004039s ]
SELECT `id` FROM `stock` WHERE `id` <> 57737657 AND `partno` = '4103CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347689 [ RunTime:0.005621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238216 LIMIT 5 [ RunTime:0.024080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238216 ORDER BY `minOrder` ASC [ RunTime:0.011735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238216 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238216 LIMIT 2 [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238216 ORDER BY `minOrder` ASC [ RunTime:0.003283s ]
select * from pdf where partno='4103' and brandshort='Pololu' limit 1 [ RunTime:0.016287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.013229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714093 LIMIT 5 [ RunTime:0.004893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714093 ORDER BY `minOrder` ASC [ RunTime:0.028533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714093 ORDER BY `unit` DESC [ RunTime:0.026705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714093 LIMIT 2 [ RunTime:0.024972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714093 ORDER BY `minOrder` ASC [ RunTime:0.002221s ]
select * from pdf where partno='41037' and brandshort='Brady Corporation' limit 1 [ RunTime:0.063181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41037' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.013945s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714093 AND `partno` = '41037' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.031378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425436 [ RunTime:0.025397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714081 LIMIT 5 [ RunTime:0.025139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714081 ORDER BY `minOrder` ASC [ RunTime:0.039284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714081 ORDER BY `unit` DESC [ RunTime:0.028155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714081 LIMIT 2 [ RunTime:0.020011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714081 ORDER BY `minOrder` ASC [ RunTime:0.003052s ]
select * from pdf where partno='41035' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41035' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.045591s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714081 AND `partno` = '41035' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556504 [ RunTime:0.028117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714068 LIMIT 5 [ RunTime:0.014554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714068 ORDER BY `minOrder` ASC [ RunTime:0.042857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714068 ORDER BY `unit` DESC [ RunTime:0.030500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714068 LIMIT 2 [ RunTime:0.036340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714068 ORDER BY `minOrder` ASC [ RunTime:0.004563s ]
select * from pdf where partno='41030' and brandshort='Brady Corporation' limit 1 [ RunTime:0.037404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41030' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.011304s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714068 AND `partno` = '41030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.031328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556497 [ RunTime:0.020515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714055 LIMIT 5 [ RunTime:0.014724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714055 ORDER BY `minOrder` ASC [ RunTime:0.014521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714055 ORDER BY `unit` DESC [ RunTime:0.004308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714055 LIMIT 2 [ RunTime:0.044835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714055 ORDER BY `minOrder` ASC [ RunTime:0.011062s ]
select * from pdf where partno='41038' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41038' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001372s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714055 AND `partno` = '41038' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.011357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425414 [ RunTime:0.016037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714054 LIMIT 5 [ RunTime:0.016689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714054 ORDER BY `minOrder` ASC [ RunTime:0.035651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714054 ORDER BY `unit` DESC [ RunTime:0.023471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714054 LIMIT 2 [ RunTime:0.008323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714054 ORDER BY `minOrder` ASC [ RunTime:0.014213s ]
select * from pdf where partno='41033' and brandshort='Brady Corporation' limit 1 [ RunTime:0.015209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41033' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.040419s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714054 AND `partno` = '41033' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.022163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425413 [ RunTime:0.012321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714045 LIMIT 5 [ RunTime:0.037883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714045 ORDER BY `minOrder` ASC [ RunTime:0.007216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714045 ORDER BY `unit` DESC [ RunTime:0.018879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714045 LIMIT 2 [ RunTime:0.017469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714045 ORDER BY `minOrder` ASC [ RunTime:0.029739s ]
select * from pdf where partno='41031' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41031' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004797s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714045 AND `partno` = '41031' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425408 [ RunTime:0.008768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714040 LIMIT 5 [ RunTime:0.008790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714040 ORDER BY `minOrder` ASC [ RunTime:0.004356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714040 ORDER BY `unit` DESC [ RunTime:0.010309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714040 LIMIT 2 [ RunTime:0.051244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714040 ORDER BY `minOrder` ASC [ RunTime:0.004698s ]
select * from pdf where partno='41036' and brandshort='Brady Corporation' limit 1 [ RunTime:0.018870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41036' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.032062s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714040 AND `partno` = '41036' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.020684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556486 [ RunTime:0.015448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714028 LIMIT 5 [ RunTime:0.039233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714028 ORDER BY `minOrder` ASC [ RunTime:0.003751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714028 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714028 LIMIT 2 [ RunTime:0.012825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714028 ORDER BY `minOrder` ASC [ RunTime:0.003408s ]
select * from pdf where partno='41034' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41034' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010084s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714028 AND `partno` = '41034' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.015300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425398 [ RunTime:0.010033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714016 LIMIT 5 [ RunTime:0.010177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714016 ORDER BY `minOrder` ASC [ RunTime:0.010254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714016 ORDER BY `unit` DESC [ RunTime:0.002612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714016 LIMIT 2 [ RunTime:0.002516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714016 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='41032' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41032' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.025924s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714016 AND `partno` = '41032' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.024057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556477 [ RunTime:0.018080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57704044 LIMIT 5 [ RunTime:0.013623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57704044 ORDER BY `minOrder` ASC [ RunTime:0.002173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57704044 ORDER BY `unit` DESC [ RunTime:0.008542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57704044 LIMIT 2 [ RunTime:0.033304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57704044 ORDER BY `minOrder` ASC [ RunTime:0.011638s ]
select * from pdf where partno='4103-H' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103-H' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.054737s ]
SELECT `id` FROM `stock` WHERE `id` <> 57704044 AND `partno` = '4103-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.029838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457963 [ RunTime:0.009502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703506 LIMIT 5 [ RunTime:0.010994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703506 ORDER BY `minOrder` ASC [ RunTime:0.014011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703506 ORDER BY `unit` DESC [ RunTime:0.011673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703506 LIMIT 2 [ RunTime:0.007263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703506 ORDER BY `minOrder` ASC [ RunTime:0.008619s ]
select * from pdf where partno='4103-F' and brandshort='Brady Corporation' limit 1 [ RunTime:0.028431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103-F' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020761s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703506 AND `partno` = '4103-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.015157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459915 [ RunTime:0.002966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703370 LIMIT 5 [ RunTime:0.004409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703370 ORDER BY `minOrder` ASC [ RunTime:0.017121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703370 ORDER BY `unit` DESC [ RunTime:0.013329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703370 LIMIT 2 [ RunTime:0.004457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703370 ORDER BY `minOrder` ASC [ RunTime:0.014318s ]
select * from pdf where partno='4103-D' and brandshort='Brady Corporation' limit 1 [ RunTime:0.038446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103-D' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009551s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703370 AND `partno` = '4103-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.011638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345574 [ RunTime:0.012824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703177 LIMIT 5 [ RunTime:0.003562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703177 ORDER BY `minOrder` ASC [ RunTime:0.023973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703177 ORDER BY `unit` DESC [ RunTime:0.004272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703177 LIMIT 2 [ RunTime:0.015599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703177 ORDER BY `minOrder` ASC [ RunTime:0.015763s ]
select * from pdf where partno='4103-C' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103-C' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004946s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703177 AND `partno` = '4103-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459729 [ RunTime:0.004749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57702896 LIMIT 5 [ RunTime:0.012178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702896 ORDER BY `minOrder` ASC [ RunTime:0.016995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57702896 ORDER BY `unit` DESC [ RunTime:0.023130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57702896 LIMIT 2 [ RunTime:0.014325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702896 ORDER BY `minOrder` ASC [ RunTime:0.009874s ]
select * from pdf where partno='4103-B' and brandshort='Brady Corporation' limit 1 [ RunTime:0.038595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103-B' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022861s ]
SELECT `id` FROM `stock` WHERE `id` <> 57702896 AND `partno` = '4103-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345445 [ RunTime:0.016737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57702694 LIMIT 5 [ RunTime:0.017554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702694 ORDER BY `minOrder` ASC [ RunTime:0.008226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57702694 ORDER BY `unit` DESC [ RunTime:0.030467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57702694 LIMIT 2 [ RunTime:0.015058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57702694 ORDER BY `minOrder` ASC [ RunTime:0.001650s ]
select * from pdf where partno='4103-A' and brandshort='Brady Corporation' limit 1 [ RunTime:0.022381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103-A' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007734s ]
SELECT `id` FROM `stock` WHERE `id` <> 57702694 AND `partno` = '4103-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.015107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458296 [ RunTime:0.009704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57204626 LIMIT 5 [ RunTime:0.016366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57204626 ORDER BY `minOrder` ASC [ RunTime:0.014883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57204626 ORDER BY `unit` DESC [ RunTime:0.018803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57204626 LIMIT 2 [ RunTime:0.013291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57204626 ORDER BY `minOrder` ASC [ RunTime:0.013130s ]
select * from pdf where partno='4103' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.015298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.002601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56678534 LIMIT 5 [ RunTime:0.003129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56678534 ORDER BY `minOrder` ASC [ RunTime:0.022158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56678534 ORDER BY `unit` DESC [ RunTime:0.014345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56678534 LIMIT 2 [ RunTime:0.004210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56678534 ORDER BY `minOrder` ASC [ RunTime:0.012172s ]
select * from pdf where partno='4103942' and brandshort='Simco-Ion' limit 1 [ RunTime:0.008624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4103942' OR `brand` LIKE 'Simco-Ion%' ) ) LIMIT 1 [ RunTime:0.008121s ]
SELECT `id` FROM `stock` WHERE `id` <> 56678534 AND `partno` = '4103942' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%simco-ion%' ) [ RunTime:0.014593s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016491s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002589s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000877s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012607s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015375s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006798s ]
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 '4103%' OR `brand` LIKE '4103%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005953s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4103%' OR `brand` LIKE '4103%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024247s ]