SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001198s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=86031&search=1' [ RunTime:0.001600s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001826s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000494s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001343s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003062s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001260s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000254s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001265s ]
SELECT * FROM `stock_search` WHERE `partno` = '86031' LIMIT 1 [ RunTime:0.005860s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-26 18:35:59' WHERE `partno` = '86031' [ RunTime:0.021494s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002358s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021615s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352854 LIMIT 5 [ RunTime:0.008418s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352854 ORDER BY `minOrder` ASC [ RunTime:0.026071s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14352854 ORDER BY `unit` DESC [ RunTime:0.010780s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14352854 LIMIT 2 [ RunTime:0.012237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352854 ORDER BY `minOrder` ASC [ RunTime:0.010777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352835 LIMIT 5 [ RunTime:0.014731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352835 ORDER BY `minOrder` ASC [ RunTime:0.007850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14352835 ORDER BY `unit` DESC [ RunTime:0.013638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14352835 LIMIT 2 [ RunTime:0.027937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352835 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008684s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64502845 LIMIT 5 [ RunTime:0.021042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64502845 ORDER BY `minOrder` ASC [ RunTime:0.066680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64502845 ORDER BY `unit` DESC [ RunTime:0.016366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64502845 LIMIT 2 [ RunTime:0.084827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64502845 ORDER BY `minOrder` ASC [ RunTime:0.009457s ]
select * from pdf where partno='8603148000' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.020909s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603148000' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.021045s ]
SELECT `id` FROM `stock` WHERE `id` <> 64502845 AND `partno` = '8603148000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.054509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64501903 LIMIT 5 [ RunTime:0.042171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501903 ORDER BY `minOrder` ASC [ RunTime:0.063760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64501903 ORDER BY `unit` DESC [ RunTime:0.049555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64501903 LIMIT 2 [ RunTime:0.036346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501903 ORDER BY `minOrder` ASC [ RunTime:0.030769s ]
select * from pdf where partno='8603146006' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.067642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603146006' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.028967s ]
SELECT `id` FROM `stock` WHERE `id` <> 64501903 AND `partno` = '8603146006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.012262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64501674 LIMIT 5 [ RunTime:0.023400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501674 ORDER BY `minOrder` ASC [ RunTime:0.014984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64501674 ORDER BY `unit` DESC [ RunTime:0.014997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64501674 LIMIT 2 [ RunTime:0.023305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501674 ORDER BY `minOrder` ASC [ RunTime:0.018124s ]
select * from pdf where partno='8603146002' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.043061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603146002' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.014940s ]
SELECT `id` FROM `stock` WHERE `id` <> 64501674 AND `partno` = '8603146002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.054554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64500987 LIMIT 5 [ RunTime:0.018177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500987 ORDER BY `minOrder` ASC [ RunTime:0.018752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64500987 ORDER BY `unit` DESC [ RunTime:0.031199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64500987 LIMIT 2 [ RunTime:0.052354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500987 ORDER BY `minOrder` ASC [ RunTime:0.026425s ]
select * from pdf where partno='8603146003' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.028447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603146003' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.041275s ]
SELECT `id` FROM `stock` WHERE `id` <> 64500987 AND `partno` = '8603146003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.047554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64500882 LIMIT 5 [ RunTime:0.045732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500882 ORDER BY `minOrder` ASC [ RunTime:0.030113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64500882 ORDER BY `unit` DESC [ RunTime:0.013645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64500882 LIMIT 2 [ RunTime:0.019450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500882 ORDER BY `minOrder` ASC [ RunTime:0.004449s ]
select * from pdf where partno='8603126016' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.045301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603126016' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.024362s ]
SELECT `id` FROM `stock` WHERE `id` <> 64500882 AND `partno` = '8603126016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.045776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64500453 LIMIT 5 [ RunTime:0.030084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500453 ORDER BY `minOrder` ASC [ RunTime:0.040750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64500453 ORDER BY `unit` DESC [ RunTime:0.023041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64500453 LIMIT 2 [ RunTime:0.030806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500453 ORDER BY `minOrder` ASC [ RunTime:0.018361s ]
select * from pdf where partno='8603116009' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.027468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603116009' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.028632s ]
SELECT `id` FROM `stock` WHERE `id` <> 64500453 AND `partno` = '8603116009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.034250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64500419 LIMIT 5 [ RunTime:0.028213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500419 ORDER BY `minOrder` ASC [ RunTime:0.021235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64500419 ORDER BY `unit` DESC [ RunTime:0.044762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64500419 LIMIT 2 [ RunTime:0.062908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500419 ORDER BY `minOrder` ASC [ RunTime:0.037354s ]
select * from pdf where partno='8603126010' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.021633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603126010' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.040006s ]
SELECT `id` FROM `stock` WHERE `id` <> 64500419 AND `partno` = '8603126010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.029599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64500409 LIMIT 5 [ RunTime:0.060680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500409 ORDER BY `minOrder` ASC [ RunTime:0.064610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64500409 ORDER BY `unit` DESC [ RunTime:0.008977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64500409 LIMIT 2 [ RunTime:0.024600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500409 ORDER BY `minOrder` ASC [ RunTime:0.009103s ]
select * from pdf where partno='8603120004' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.031147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603120004' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.031948s ]
SELECT `id` FROM `stock` WHERE `id` <> 64500409 AND `partno` = '8603120004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.059960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64500317 LIMIT 5 [ RunTime:0.029132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500317 ORDER BY `minOrder` ASC [ RunTime:0.021031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64500317 ORDER BY `unit` DESC [ RunTime:0.047043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64500317 LIMIT 2 [ RunTime:0.012531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500317 ORDER BY `minOrder` ASC [ RunTime:0.009244s ]
select * from pdf where partno='8603126012' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.008138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603126012' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.027027s ]
SELECT `id` FROM `stock` WHERE `id` <> 64500317 AND `partno` = '8603126012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.058089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64500034 LIMIT 5 [ RunTime:0.022585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500034 ORDER BY `minOrder` ASC [ RunTime:0.035976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64500034 ORDER BY `unit` DESC [ RunTime:0.006646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64500034 LIMIT 2 [ RunTime:0.073012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500034 ORDER BY `minOrder` ASC [ RunTime:0.096283s ]
select * from pdf where partno='8603126017' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.014350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603126017' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.043621s ]
SELECT `id` FROM `stock` WHERE `id` <> 64500034 AND `partno` = '8603126017' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.073424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64499863 LIMIT 5 [ RunTime:0.039013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64499863 ORDER BY `minOrder` ASC [ RunTime:0.033069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64499863 ORDER BY `unit` DESC [ RunTime:0.024957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64499863 LIMIT 2 [ RunTime:0.019506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64499863 ORDER BY `minOrder` ASC [ RunTime:0.091235s ]
select * from pdf where partno='8603126029' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.018026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603126029' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.037898s ]
SELECT `id` FROM `stock` WHERE `id` <> 64499863 AND `partno` = '8603126029' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.046537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498597 LIMIT 5 [ RunTime:0.032561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498597 ORDER BY `minOrder` ASC [ RunTime:0.009957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498597 ORDER BY `unit` DESC [ RunTime:0.006977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498597 LIMIT 2 [ RunTime:0.008360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498597 ORDER BY `minOrder` ASC [ RunTime:0.019233s ]
select * from pdf where partno='8603120005' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.027175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603120005' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.028908s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498597 AND `partno` = '8603120005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498596 LIMIT 5 [ RunTime:0.011206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498596 ORDER BY `minOrder` ASC [ RunTime:0.018615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498596 ORDER BY `unit` DESC [ RunTime:0.012093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498596 LIMIT 2 [ RunTime:0.034899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498596 ORDER BY `minOrder` ASC [ RunTime:0.020099s ]
select * from pdf where partno='8603120003' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.019581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603120003' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.036359s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498596 AND `partno` = '8603120003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.032105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498496 LIMIT 5 [ RunTime:0.046448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498496 ORDER BY `minOrder` ASC [ RunTime:0.026223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498496 ORDER BY `unit` DESC [ RunTime:0.021184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498496 LIMIT 2 [ RunTime:0.032693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498496 ORDER BY `minOrder` ASC [ RunTime:0.025260s ]
select * from pdf where partno='8603126018' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.030905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603126018' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.022970s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498496 AND `partno` = '8603126018' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.070061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498430 LIMIT 5 [ RunTime:0.057273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498430 ORDER BY `minOrder` ASC [ RunTime:0.020052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498430 ORDER BY `unit` DESC [ RunTime:0.065856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498430 LIMIT 2 [ RunTime:0.085441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498430 ORDER BY `minOrder` ASC [ RunTime:0.049185s ]
select * from pdf where partno='8603126006' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.029819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603126006' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.007450s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498430 AND `partno` = '8603126006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.013769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352854 [ RunTime:0.011901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498410 LIMIT 5 [ RunTime:0.010770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498410 ORDER BY `minOrder` ASC [ RunTime:0.007216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498410 ORDER BY `unit` DESC [ RunTime:0.010263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498410 LIMIT 2 [ RunTime:0.001024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498410 ORDER BY `minOrder` ASC [ RunTime:0.009198s ]
select * from pdf where partno='8603126002' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.025250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603126002' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.005677s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498410 AND `partno` = '8603126002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.032542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498367 LIMIT 5 [ RunTime:0.034823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498367 ORDER BY `minOrder` ASC [ RunTime:0.009691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498367 ORDER BY `unit` DESC [ RunTime:0.013331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498367 LIMIT 2 [ RunTime:0.017054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498367 ORDER BY `minOrder` ASC [ RunTime:0.011239s ]
select * from pdf where partno='8603146004' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.008525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603146004' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.025934s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498367 AND `partno` = '8603146004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.047906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352835 [ RunTime:0.038040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498210 LIMIT 5 [ RunTime:0.029349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498210 ORDER BY `minOrder` ASC [ RunTime:0.023004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498210 ORDER BY `unit` DESC [ RunTime:0.060142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498210 LIMIT 2 [ RunTime:0.024659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498210 ORDER BY `minOrder` ASC [ RunTime:0.010654s ]
select * from pdf where partno='8603146007' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.033938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603146007' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.027120s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498210 AND `partno` = '8603146007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.097071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498143 LIMIT 5 [ RunTime:0.011380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498143 ORDER BY `minOrder` ASC [ RunTime:0.026266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498143 ORDER BY `unit` DESC [ RunTime:0.062070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498143 LIMIT 2 [ RunTime:0.023883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498143 ORDER BY `minOrder` ASC [ RunTime:0.038938s ]
select * from pdf where partno='8603146001' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.021812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603146001' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.018937s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498143 AND `partno` = '8603146001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.024535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64498114 LIMIT 5 [ RunTime:0.033490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498114 ORDER BY `minOrder` ASC [ RunTime:0.022930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64498114 ORDER BY `unit` DESC [ RunTime:0.022713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64498114 LIMIT 2 [ RunTime:0.022597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64498114 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
select * from pdf where partno='8603146005' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.013935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8603146005' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.015251s ]
SELECT `id` FROM `stock` WHERE `id` <> 64498114 AND `partno` = '8603146005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.020618s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031599s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024626s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017709s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020144s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016934s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066798s ]
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 '86031%' OR `brand` LIKE '86031%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013059s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '86031%' OR `brand` LIKE '86031%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022884s ]