SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002207s ]
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=9421&search=1' [ RunTime:0.005861s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003058s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007566s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001579s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002801s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002401s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007389s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001413s ]
SELECT * FROM `stock_search` WHERE `partno` = '9421' LIMIT 1 [ RunTime:0.002909s ]
UPDATE `stock_search` SET `count` = 20 , `updatetime` = '2026-08-20 08:27:29' WHERE `partno` = '9421' [ RunTime:0.003799s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001225s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040790s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225159 LIMIT 5 [ RunTime:0.034241s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225159 ORDER BY `minOrder` ASC [ RunTime:0.007108s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11225159 ORDER BY `unit` DESC [ RunTime:0.008352s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11225159 LIMIT 2 [ RunTime:0.011775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225159 ORDER BY `minOrder` ASC [ RunTime:0.019865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498312 LIMIT 5 [ RunTime:0.035421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13498312 ORDER BY `minOrder` ASC [ RunTime:0.030096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13498312 ORDER BY `unit` DESC [ RunTime:0.012127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13498312 LIMIT 2 [ RunTime:0.005144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13498312 ORDER BY `minOrder` ASC [ RunTime:0.004125s ]
select * from pdf where partno='9421 060U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.028800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12048367 LIMIT 5 [ RunTime:0.015108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12048367 ORDER BY `minOrder` ASC [ RunTime:0.032610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12048367 ORDER BY `unit` DESC [ RunTime:0.014060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12048367 LIMIT 2 [ RunTime:0.011339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12048367 ORDER BY `minOrder` ASC [ RunTime:0.006092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12221868 LIMIT 5 [ RunTime:0.010550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221868 ORDER BY `minOrder` ASC [ RunTime:0.020664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12221868 ORDER BY `unit` DESC [ RunTime:0.008590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12221868 LIMIT 2 [ RunTime:0.007702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221868 ORDER BY `minOrder` ASC [ RunTime:0.008311s ]
select * from pdf where partno='942194002' and brandshort='Hirschmann' limit 1 [ RunTime:0.009034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385626 LIMIT 5 [ RunTime:0.012709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385626 ORDER BY `minOrder` ASC [ RunTime:0.013533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385626 ORDER BY `unit` DESC [ RunTime:0.036862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385626 LIMIT 2 [ RunTime:0.013703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385626 ORDER BY `minOrder` ASC [ RunTime:0.059543s ]
select * from pdf where partno='9421 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.018902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12221992 LIMIT 5 [ RunTime:0.019552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221992 ORDER BY `minOrder` ASC [ RunTime:0.055465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12221992 ORDER BY `unit` DESC [ RunTime:0.026745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12221992 LIMIT 2 [ RunTime:0.042145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221992 ORDER BY `minOrder` ASC [ RunTime:0.015912s ]
select * from pdf where partno='942196002' and brandshort='Hirschmann' limit 1 [ RunTime:0.047747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387443 LIMIT 5 [ RunTime:0.040367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387443 ORDER BY `minOrder` ASC [ RunTime:0.060370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387443 ORDER BY `unit` DESC [ RunTime:0.012206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387443 LIMIT 2 [ RunTime:0.074136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387443 ORDER BY `minOrder` ASC [ RunTime:0.010451s ]
select * from pdf where partno='9421 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.025123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14712014 LIMIT 5 [ RunTime:0.041258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14712014 ORDER BY `minOrder` ASC [ RunTime:0.038455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14712014 ORDER BY `unit` DESC [ RunTime:0.027809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14712014 LIMIT 2 [ RunTime:0.064186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14712014 ORDER BY `minOrder` ASC [ RunTime:0.017284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278774 LIMIT 5 [ RunTime:0.020282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278774 ORDER BY `minOrder` ASC [ RunTime:0.045712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278774 ORDER BY `unit` DESC [ RunTime:0.014603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278774 LIMIT 2 [ RunTime:0.014007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278774 ORDER BY `minOrder` ASC [ RunTime:0.014352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278773 LIMIT 5 [ RunTime:0.021814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278773 ORDER BY `minOrder` ASC [ RunTime:0.027123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278773 ORDER BY `unit` DESC [ RunTime:0.026930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278773 LIMIT 2 [ RunTime:0.008943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278773 ORDER BY `minOrder` ASC [ RunTime:0.005832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12007052 LIMIT 5 [ RunTime:0.004679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12007052 ORDER BY `minOrder` ASC [ RunTime:0.034406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12007052 ORDER BY `unit` DESC [ RunTime:0.009812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12007052 LIMIT 2 [ RunTime:0.019062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12007052 ORDER BY `minOrder` ASC [ RunTime:0.009219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12007048 LIMIT 5 [ RunTime:0.020078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12007048 ORDER BY `minOrder` ASC [ RunTime:0.013247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12007048 ORDER BY `unit` DESC [ RunTime:0.030889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12007048 LIMIT 2 [ RunTime:0.014900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12007048 ORDER BY `minOrder` ASC [ RunTime:0.002015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12007045 LIMIT 5 [ RunTime:0.010319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12007045 ORDER BY `minOrder` ASC [ RunTime:0.002001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12007045 ORDER BY `unit` DESC [ RunTime:0.011326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12007045 LIMIT 2 [ RunTime:0.018432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12007045 ORDER BY `minOrder` ASC [ RunTime:0.007892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11223842 LIMIT 5 [ RunTime:0.019157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11223842 ORDER BY `minOrder` ASC [ RunTime:0.009876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11223842 ORDER BY `unit` DESC [ RunTime:0.009752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11223842 LIMIT 2 [ RunTime:0.010287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11223842 ORDER BY `minOrder` ASC [ RunTime:0.002404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14709567 LIMIT 5 [ RunTime:0.001932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709567 ORDER BY `minOrder` ASC [ RunTime:0.006314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14709567 ORDER BY `unit` DESC [ RunTime:0.009435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14709567 LIMIT 2 [ RunTime:0.002953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709567 ORDER BY `minOrder` ASC [ RunTime:0.008319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14709553 LIMIT 5 [ RunTime:0.009828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709553 ORDER BY `minOrder` ASC [ RunTime:0.006159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14709553 ORDER BY `unit` DESC [ RunTime:0.012471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14709553 LIMIT 2 [ RunTime:0.014372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709553 ORDER BY `minOrder` ASC [ RunTime:0.002490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13819204 LIMIT 5 [ RunTime:0.011055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13819204 ORDER BY `minOrder` ASC [ RunTime:0.001975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13819204 ORDER BY `unit` DESC [ RunTime:0.011234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13819204 LIMIT 2 [ RunTime:0.002538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13819204 ORDER BY `minOrder` ASC [ RunTime:0.002739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12005427 LIMIT 5 [ RunTime:0.001826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12005427 ORDER BY `minOrder` ASC [ RunTime:0.008280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12005427 ORDER BY `unit` DESC [ RunTime:0.041149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12005427 LIMIT 2 [ RunTime:0.005270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12005427 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14709581 LIMIT 5 [ RunTime:0.006790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709581 ORDER BY `minOrder` ASC [ RunTime:0.008313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14709581 ORDER BY `unit` DESC [ RunTime:0.000554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14709581 LIMIT 2 [ RunTime:0.001248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709581 ORDER BY `minOrder` ASC [ RunTime:0.002642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14709572 LIMIT 5 [ RunTime:0.024753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709572 ORDER BY `minOrder` ASC [ RunTime:0.009845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14709572 ORDER BY `unit` DESC [ RunTime:0.042114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14709572 LIMIT 2 [ RunTime:0.013556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709572 ORDER BY `minOrder` ASC [ RunTime:0.006949s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137493 LIMIT 5 [ RunTime:0.020806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137493 ORDER BY `minOrder` ASC [ RunTime:0.027798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137493 ORDER BY `unit` DESC [ RunTime:0.022521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137493 LIMIT 2 [ RunTime:0.025774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137493 ORDER BY `minOrder` ASC [ RunTime:0.033880s ]
select * from pdf where partno='9421 060100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.026219s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421 060100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.017816s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137493 AND `partno` = '9421 060100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.030930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137494 LIMIT 5 [ RunTime:0.031813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137494 ORDER BY `minOrder` ASC [ RunTime:0.050190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137494 ORDER BY `unit` DESC [ RunTime:0.002512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137494 LIMIT 2 [ RunTime:0.037680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137494 ORDER BY `minOrder` ASC [ RunTime:0.007111s ]
select * from pdf where partno='9421 060500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.023976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421 060500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.075934s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137494 AND `partno` = '9421 060500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.036388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51136921 LIMIT 5 [ RunTime:0.016878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136921 ORDER BY `minOrder` ASC [ RunTime:0.018977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51136921 ORDER BY `unit` DESC [ RunTime:0.003912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51136921 LIMIT 2 [ RunTime:0.036681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136921 ORDER BY `minOrder` ASC [ RunTime:0.112977s ]
select * from pdf where partno='9421 0601000' and brandshort='belden wire & cable' limit 1 [ RunTime:0.030152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421 0601000' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.030336s ]
SELECT `id` FROM `stock` WHERE `id` <> 51136921 AND `partno` = '9421 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.045905s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.121954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001514 LIMIT 5 [ RunTime:0.013819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001514 ORDER BY `minOrder` ASC [ RunTime:0.039368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001514 ORDER BY `unit` DESC [ RunTime:0.014638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001514 LIMIT 2 [ RunTime:0.008387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001514 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
select * from pdf where partno='9421 0605000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.012220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421 0605000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.013745s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001514 AND `partno` = '9421 0605000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.015988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13500092 [ RunTime:0.015320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58143208 LIMIT 5 [ RunTime:0.022255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143208 ORDER BY `minOrder` ASC [ RunTime:0.020274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58143208 ORDER BY `unit` DESC [ RunTime:0.002834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58143208 LIMIT 2 [ RunTime:0.006889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143208 ORDER BY `minOrder` ASC [ RunTime:0.008360s ]
select * from pdf where partno='942196001-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.024469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942196001-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.014137s ]
SELECT `id` FROM `stock` WHERE `id` <> 58143208 AND `partno` = '942196001-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.005221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58143842 LIMIT 5 [ RunTime:0.022560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143842 ORDER BY `minOrder` ASC [ RunTime:0.016837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58143842 ORDER BY `unit` DESC [ RunTime:0.030867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58143842 LIMIT 2 [ RunTime:0.025436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143842 ORDER BY `minOrder` ASC [ RunTime:0.017801s ]
select * from pdf where partno='942196002-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.034830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942196002-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.055871s ]
SELECT `id` FROM `stock` WHERE `id` <> 58143842 AND `partno` = '942196002-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.045207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225159 [ RunTime:0.016013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63368386 LIMIT 5 [ RunTime:0.021611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63368386 ORDER BY `minOrder` ASC [ RunTime:0.015600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63368386 ORDER BY `unit` DESC [ RunTime:0.063966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63368386 LIMIT 2 [ RunTime:0.099770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63368386 ORDER BY `minOrder` ASC [ RunTime:0.016211s ]
select * from pdf where partno='9421' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.057745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.010344s ]
SELECT `id` FROM `stock` WHERE `id` <> 63368386 AND `partno` = '9421' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.045291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12048367 [ RunTime:0.049783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62999222 LIMIT 5 [ RunTime:0.046870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999222 ORDER BY `minOrder` ASC [ RunTime:0.080801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62999222 ORDER BY `unit` DESC [ RunTime:0.038577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62999222 LIMIT 2 [ RunTime:0.063926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999222 ORDER BY `minOrder` ASC [ RunTime:0.010471s ]
select * from pdf where partno='9421 060U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.009671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421 060U500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.044174s ]
SELECT `id` FROM `stock` WHERE `id` <> 62999222 AND `partno` = '9421 060U500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.139632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498312 [ RunTime:0.013699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58140833 LIMIT 5 [ RunTime:0.093868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58140833 ORDER BY `minOrder` ASC [ RunTime:0.048482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58140833 ORDER BY `unit` DESC [ RunTime:0.020503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58140833 LIMIT 2 [ RunTime:0.029137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58140833 ORDER BY `minOrder` ASC [ RunTime:0.037470s ]
select * from pdf where partno='942194002' and brandshort='Hirschmann' limit 1 [ RunTime:0.005084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942194002' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.024974s ]
SELECT `id` FROM `stock` WHERE `id` <> 58140833 AND `partno` = '942194002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.010896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12221868 [ RunTime:0.052678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63006462 LIMIT 5 [ RunTime:0.031459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63006462 ORDER BY `minOrder` ASC [ RunTime:0.046481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63006462 ORDER BY `unit` DESC [ RunTime:0.018790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63006462 LIMIT 2 [ RunTime:0.007784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63006462 ORDER BY `minOrder` ASC [ RunTime:0.007262s ]
select * from pdf where partno='9421 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.009334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421 060100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.013897s ]
SELECT `id` FROM `stock` WHERE `id` <> 63006462 AND `partno` = '9421 060100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.017200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385626 [ RunTime:0.004902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64379211 LIMIT 5 [ RunTime:0.045091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64379211 ORDER BY `minOrder` ASC [ RunTime:0.070368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64379211 ORDER BY `unit` DESC [ RunTime:0.005091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64379211 LIMIT 2 [ RunTime:0.028623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64379211 ORDER BY `minOrder` ASC [ RunTime:0.001687s ]
select * from pdf where partno='942177001' and brandshort='Hirschmann' limit 1 [ RunTime:0.028373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942177001' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.041985s ]
SELECT `id` FROM `stock` WHERE `id` <> 64379211 AND `partno` = '942177001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.024577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13276956 [ RunTime:0.017321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58156580 LIMIT 5 [ RunTime:0.011865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58156580 ORDER BY `minOrder` ASC [ RunTime:0.018982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58156580 ORDER BY `unit` DESC [ RunTime:0.037647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58156580 LIMIT 2 [ RunTime:0.019436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58156580 ORDER BY `minOrder` ASC [ RunTime:0.007835s ]
select * from pdf where partno='942195002' and brandshort='Hirschmann' limit 1 [ RunTime:0.017971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942195002' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.007974s ]
SELECT `id` FROM `stock` WHERE `id` <> 58156580 AND `partno` = '942195002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.037789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11223831 [ RunTime:0.016201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64384352 LIMIT 5 [ RunTime:0.009984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384352 ORDER BY `minOrder` ASC [ RunTime:0.018111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64384352 ORDER BY `unit` DESC [ RunTime:0.011353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64384352 LIMIT 2 [ RunTime:0.014695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384352 ORDER BY `minOrder` ASC [ RunTime:0.006759s ]
select * from pdf where partno='942106999-21' and brandshort='Hirschmann' limit 1 [ RunTime:0.000894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942106999-21' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.003581s ]
SELECT `id` FROM `stock` WHERE `id` <> 64384352 AND `partno` = '942106999-21' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.021693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63007160 LIMIT 5 [ RunTime:0.008807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007160 ORDER BY `minOrder` ASC [ RunTime:0.006806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63007160 ORDER BY `unit` DESC [ RunTime:0.004899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63007160 LIMIT 2 [ RunTime:0.020325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007160 ORDER BY `minOrder` ASC [ RunTime:0.008445s ]
select * from pdf where partno='9421 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.014270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421 060500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.008771s ]
SELECT `id` FROM `stock` WHERE `id` <> 63007160 AND `partno` = '9421 060500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.007023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387443 [ RunTime:0.007479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58207608 LIMIT 5 [ RunTime:0.004089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207608 ORDER BY `minOrder` ASC [ RunTime:0.016395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58207608 ORDER BY `unit` DESC [ RunTime:0.020010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58207608 LIMIT 2 [ RunTime:0.012376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207608 ORDER BY `minOrder` ASC [ RunTime:0.010547s ]
select * from pdf where partno='9421LB1' and brandshort='Schneider Electric' limit 1 [ RunTime:0.009128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421LB1' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.021013s ]
SELECT `id` FROM `stock` WHERE `id` <> 58207608 AND `partno` = '9421LB1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.040598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14712014 [ RunTime:0.029196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64384074 LIMIT 5 [ RunTime:0.040746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384074 ORDER BY `minOrder` ASC [ RunTime:0.025701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64384074 ORDER BY `unit` DESC [ RunTime:0.023278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64384074 LIMIT 2 [ RunTime:0.032350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384074 ORDER BY `minOrder` ASC [ RunTime:0.031889s ]
select * from pdf where partno='942141032' and brandshort='Hirschmann' limit 1 [ RunTime:0.079144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942141032' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.063907s ]
SELECT `id` FROM `stock` WHERE `id` <> 64384074 AND `partno` = '942141032' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.055236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12007099 [ RunTime:0.024308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58208011 LIMIT 5 [ RunTime:0.092959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58208011 ORDER BY `minOrder` ASC [ RunTime:0.016289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58208011 ORDER BY `unit` DESC [ RunTime:0.028314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58208011 LIMIT 2 [ RunTime:0.017029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58208011 ORDER BY `minOrder` ASC [ RunTime:0.010230s ]
select * from pdf where partno='9421LS8' and brandshort='Schneider Electric' limit 1 [ RunTime:0.032487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421LS8' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.011671s ]
SELECT `id` FROM `stock` WHERE `id` <> 58208011 AND `partno` = '9421LS8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.012301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58156727 LIMIT 5 [ RunTime:0.020005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58156727 ORDER BY `minOrder` ASC [ RunTime:0.008081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58156727 ORDER BY `unit` DESC [ RunTime:0.025283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58156727 LIMIT 2 [ RunTime:0.007699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58156727 ORDER BY `minOrder` ASC [ RunTime:0.008101s ]
select * from pdf where partno='942196002' and brandshort='Hirschmann' limit 1 [ RunTime:0.001803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942196002' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.004084s ]
SELECT `id` FROM `stock` WHERE `id` <> 58156727 AND `partno` = '942196002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.017851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12221992 [ RunTime:0.041434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64384286 LIMIT 5 [ RunTime:0.031868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384286 ORDER BY `minOrder` ASC [ RunTime:0.013728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64384286 ORDER BY `unit` DESC [ RunTime:0.016462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64384286 LIMIT 2 [ RunTime:0.008557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384286 ORDER BY `minOrder` ASC [ RunTime:0.014141s ]
select * from pdf where partno='942141036' and brandshort='Hirschmann' limit 1 [ RunTime:0.012137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942141036' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.026171s ]
SELECT `id` FROM `stock` WHERE `id` <> 64384286 AND `partno` = '942141036' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.009341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12007052 [ RunTime:0.013933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63007176 LIMIT 5 [ RunTime:0.010478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007176 ORDER BY `minOrder` ASC [ RunTime:0.021534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63007176 ORDER BY `unit` DESC [ RunTime:0.013706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63007176 LIMIT 2 [ RunTime:0.032189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007176 ORDER BY `minOrder` ASC [ RunTime:0.010765s ]
select * from pdf where partno='9421 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.020130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421 0601000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.037565s ]
SELECT `id` FROM `stock` WHERE `id` <> 63007176 AND `partno` = '9421 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.010500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389814 [ RunTime:0.014371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61185550 LIMIT 5 [ RunTime:0.012500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61185550 ORDER BY `minOrder` ASC [ RunTime:0.016028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61185550 ORDER BY `unit` DESC [ RunTime:0.014684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61185550 LIMIT 2 [ RunTime:0.013614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61185550 ORDER BY `minOrder` ASC [ RunTime:0.009428s ]
select * from pdf where partno='942153-000' and brandshort='WEC' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942153-000' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.009994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58207649 LIMIT 5 [ RunTime:0.008510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207649 ORDER BY `minOrder` ASC [ RunTime:0.007835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58207649 ORDER BY `unit` DESC [ RunTime:0.004897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58207649 LIMIT 2 [ RunTime:0.008187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207649 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
select * from pdf where partno='9421LR1' and brandshort='Schneider Electric' limit 1 [ RunTime:0.001082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421LR1' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.003655s ]
SELECT `id` FROM `stock` WHERE `id` <> 58207649 AND `partno` = '9421LR1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.002330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13819242 [ RunTime:0.005857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58207635 LIMIT 5 [ RunTime:0.008592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207635 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58207635 ORDER BY `unit` DESC [ RunTime:0.000681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58207635 LIMIT 2 [ RunTime:0.004179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207635 ORDER BY `minOrder` ASC [ RunTime:0.006818s ]
select * from pdf where partno='9421LJ1' and brandshort='Schneider Electric' limit 1 [ RunTime:0.010306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9421LJ1' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.007241s ]
SELECT `id` FROM `stock` WHERE `id` <> 58207635 AND `partno` = '9421LJ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.004326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13819236 [ RunTime:0.003291s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005038s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003975s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001633s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002730s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007526s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004393s ]
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 '9421%' OR `brand` LIKE '9421%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003374s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9421%' OR `brand` LIKE '9421%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014157s ]