SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001888s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=PRT1&search=1' [ RunTime:0.003299s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002640s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002116s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001758s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002619s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PRT1' LIMIT 1 [ RunTime:0.001315s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-13 15:27:26' WHERE `partno` = 'PRT1' [ RunTime:0.001790s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002313s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012915s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422353 LIMIT 5 [ RunTime:0.000783s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422353 ORDER BY `minOrder` ASC [ RunTime:0.001275s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422353 ORDER BY `unit` DESC [ RunTime:0.002369s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422353 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422353 ORDER BY `minOrder` ASC [ RunTime:0.003112s ]
select * from pdf where partno='PRT1S-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.013442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420725 LIMIT 5 [ RunTime:0.003432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16420725 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16420725 ORDER BY `unit` DESC [ RunTime:0.003857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16420725 LIMIT 2 [ RunTime:0.002301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16420725 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='PRT1.5S-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536333 LIMIT 5 [ RunTime:0.013117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536333 ORDER BY `minOrder` ASC [ RunTime:0.020516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536333 ORDER BY `unit` DESC [ RunTime:0.022531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536333 LIMIT 2 [ RunTime:0.006586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536333 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='PRT1.5S-M30' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421144 LIMIT 5 [ RunTime:0.002178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421144 ORDER BY `minOrder` ASC [ RunTime:0.005531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16421144 ORDER BY `unit` DESC [ RunTime:0.015290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16421144 LIMIT 2 [ RunTime:0.022575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421144 ORDER BY `minOrder` ASC [ RunTime:0.004121s ]
select * from pdf where partno='PRT1.5S-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.017487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407128 LIMIT 5 [ RunTime:0.001247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407128 ORDER BY `minOrder` ASC [ RunTime:0.017766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14407128 ORDER BY `unit` DESC [ RunTime:0.006365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14407128 LIMIT 2 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407128 ORDER BY `minOrder` ASC [ RunTime:0.006047s ]
select * from pdf where partno='PRT1.5S-C0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536295 LIMIT 5 [ RunTime:0.031893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536295 ORDER BY `minOrder` ASC [ RunTime:0.002775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536295 ORDER BY `unit` DESC [ RunTime:0.005747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536295 LIMIT 2 [ RunTime:0.019734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536295 ORDER BY `minOrder` ASC [ RunTime:0.003062s ]
select * from pdf where partno='PRT12EH-C0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.026648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536291 LIMIT 5 [ RunTime:0.006852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536291 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536291 ORDER BY `unit` DESC [ RunTime:0.004184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536291 LIMIT 2 [ RunTime:0.001754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536291 ORDER BY `minOrder` ASC [ RunTime:0.003003s ]
select * from pdf where partno='PRT10EH-C0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.015929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14406917 LIMIT 5 [ RunTime:0.010088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14406917 ORDER BY `minOrder` ASC [ RunTime:0.007894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14406917 ORDER BY `unit` DESC [ RunTime:0.033317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14406917 LIMIT 2 [ RunTime:0.011284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14406917 ORDER BY `minOrder` ASC [ RunTime:0.001636s ]
select * from pdf where partno='PRT10EH-Q0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.013611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407314 LIMIT 5 [ RunTime:0.001755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407314 ORDER BY `minOrder` ASC [ RunTime:0.002903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14407314 ORDER BY `unit` DESC [ RunTime:0.006060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14407314 LIMIT 2 [ RunTime:0.006608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407314 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
select * from pdf where partno='PRT10EH-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.009270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536919 LIMIT 5 [ RunTime:0.003134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536919 ORDER BY `minOrder` ASC [ RunTime:0.004287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536919 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536919 LIMIT 2 [ RunTime:0.002065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536919 ORDER BY `minOrder` ASC [ RunTime:0.002974s ]
select * from pdf where partno='PRT1S-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537920 LIMIT 5 [ RunTime:0.005574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537920 ORDER BY `minOrder` ASC [ RunTime:0.001149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13537920 ORDER BY `unit` DESC [ RunTime:0.001583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13537920 LIMIT 2 [ RunTime:0.001762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537920 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='PRT1S-M0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420982 LIMIT 5 [ RunTime:0.001334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16420982 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16420982 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16420982 LIMIT 2 [ RunTime:0.011149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16420982 ORDER BY `minOrder` ASC [ RunTime:0.005501s ]
select * from pdf where partno='PRT12EH-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421044 LIMIT 5 [ RunTime:0.003472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421044 ORDER BY `minOrder` ASC [ RunTime:0.009479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16421044 ORDER BY `unit` DESC [ RunTime:0.007037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16421044 LIMIT 2 [ RunTime:0.001426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421044 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='PRT12EH-Q0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18833583 LIMIT 5 [ RunTime:0.004701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833583 ORDER BY `minOrder` ASC [ RunTime:0.001899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18833583 ORDER BY `unit` DESC [ RunTime:0.007138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18833583 LIMIT 2 [ RunTime:0.003905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833583 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17020599 LIMIT 5 [ RunTime:0.001324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17020599 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17020599 ORDER BY `unit` DESC [ RunTime:0.007406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17020599 LIMIT 2 [ RunTime:0.009512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17020599 ORDER BY `minOrder` ASC [ RunTime:0.014025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422077 LIMIT 5 [ RunTime:0.024270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422077 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422077 ORDER BY `unit` DESC [ RunTime:0.001143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422077 LIMIT 2 [ RunTime:0.017510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422077 ORDER BY `minOrder` ASC [ RunTime:0.004465s ]
select * from pdf where partno='PRT1S-C0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407338 LIMIT 5 [ RunTime:0.013763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407338 ORDER BY `minOrder` ASC [ RunTime:0.020088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14407338 ORDER BY `unit` DESC [ RunTime:0.004883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14407338 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407338 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='PRT1.5S-M0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.008128s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008951s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63088146 LIMIT 5 [ RunTime:0.003716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088146 ORDER BY `minOrder` ASC [ RunTime:0.004683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63088146 ORDER BY `unit` DESC [ RunTime:0.013616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63088146 LIMIT 2 [ RunTime:0.003500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088146 ORDER BY `minOrder` ASC [ RunTime:0.002692s ]
select * from pdf where partno='PRT1S-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002212s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1S-M' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003366s ]
SELECT `id` FROM `stock` WHERE `id` <> 63088146 AND `partno` = 'PRT1S-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.012632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422353 [ RunTime:0.000598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63088818 LIMIT 5 [ RunTime:0.001624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088818 ORDER BY `minOrder` ASC [ RunTime:0.005369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63088818 ORDER BY `unit` DESC [ RunTime:0.013098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63088818 LIMIT 2 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088818 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='PRT1.5S-M30' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1.5S-M30' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000561s ]
SELECT `id` FROM `stock` WHERE `id` <> 63088818 AND `partno` = 'PRT1.5S-M30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536333 [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089493 LIMIT 5 [ RunTime:0.003624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089493 ORDER BY `minOrder` ASC [ RunTime:0.004756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089493 ORDER BY `unit` DESC [ RunTime:0.001119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089493 LIMIT 2 [ RunTime:0.000968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089493 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='PRT1.5S-C0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1.5S-C0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000780s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089493 AND `partno` = 'PRT1.5S-C0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407128 [ RunTime:0.014241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089208 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089208 ORDER BY `minOrder` ASC [ RunTime:0.001205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089208 ORDER BY `unit` DESC [ RunTime:0.010140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089208 LIMIT 2 [ RunTime:0.002314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089208 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='PRT1.5S-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1.5S-C' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000824s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089208 AND `partno` = 'PRT1.5S-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.001000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421144 [ RunTime:0.001467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089557 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089557 ORDER BY `minOrder` ASC [ RunTime:0.006771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089557 ORDER BY `unit` DESC [ RunTime:0.005475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089557 LIMIT 2 [ RunTime:0.003784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089557 ORDER BY `minOrder` ASC [ RunTime:0.006137s ]
select * from pdf where partno='PRT10EH-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT10EH-C' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001191s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089557 AND `partno` = 'PRT10EH-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.002452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407314 [ RunTime:0.008154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089719 LIMIT 5 [ RunTime:0.009342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089719 ORDER BY `minOrder` ASC [ RunTime:0.001195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089719 ORDER BY `unit` DESC [ RunTime:0.002299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089719 LIMIT 2 [ RunTime:0.011283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089719 ORDER BY `minOrder` ASC [ RunTime:0.024352s ]
select * from pdf where partno='PRT12EH-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT12EH-C' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.006088s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089719 AND `partno` = 'PRT12EH-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.018549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420982 [ RunTime:0.001021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089720 LIMIT 5 [ RunTime:0.014400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089720 ORDER BY `minOrder` ASC [ RunTime:0.016739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089720 ORDER BY `unit` DESC [ RunTime:0.016984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089720 LIMIT 2 [ RunTime:0.004987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089720 ORDER BY `minOrder` ASC [ RunTime:0.004302s ]
select * from pdf where partno='PRT12EH-Q0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT12EH-Q0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.006965s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089720 AND `partno` = 'PRT12EH-Q0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.003735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421044 [ RunTime:0.004889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546778 LIMIT 5 [ RunTime:0.002493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546778 ORDER BY `minOrder` ASC [ RunTime:0.023002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546778 ORDER BY `unit` DESC [ RunTime:0.001607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546778 LIMIT 2 [ RunTime:0.009658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546778 ORDER BY `minOrder` ASC [ RunTime:0.001953s ]
select * from pdf where partno='PRT1' and brandshort='HellermannTyton' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1' OR `brand` LIKE 'HellermannTyton%' ) ) LIMIT 1 [ RunTime:0.004735s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546778 AND `partno` = 'PRT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hellermanntyton%' ) [ RunTime:0.008607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64067791 LIMIT 5 [ RunTime:0.013880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64067791 ORDER BY `minOrder` ASC [ RunTime:0.005018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64067791 ORDER BY `unit` DESC [ RunTime:0.011360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64067791 LIMIT 2 [ RunTime:0.002211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64067791 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='PRT1-SCU11' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.002267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1-SCU11' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000792s ]
SELECT `id` FROM `stock` WHERE `id` <> 64067791 AND `partno` = 'PRT1-SCU11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.006385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18833583 [ RunTime:0.004486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64067432 LIMIT 5 [ RunTime:0.004795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64067432 ORDER BY `minOrder` ASC [ RunTime:0.001716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64067432 ORDER BY `unit` DESC [ RunTime:0.005610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64067432 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64067432 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='PRT1-COM' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.002080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1-COM' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000765s ]
SELECT `id` FROM `stock` WHERE `id` <> 64067432 AND `partno` = 'PRT1-COM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17020599 [ RunTime:0.004031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63092510 LIMIT 5 [ RunTime:0.009424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63092510 ORDER BY `minOrder` ASC [ RunTime:0.007481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63092510 ORDER BY `unit` DESC [ RunTime:0.006045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63092510 LIMIT 2 [ RunTime:0.002146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63092510 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='PRT10EH-Q0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT10EH-Q0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000973s ]
SELECT `id` FROM `stock` WHERE `id` <> 63092510 AND `partno` = 'PRT10EH-Q0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.006965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14406917 [ RunTime:0.003674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63091158 LIMIT 5 [ RunTime:0.001656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63091158 ORDER BY `minOrder` ASC [ RunTime:0.003432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63091158 ORDER BY `unit` DESC [ RunTime:0.005927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63091158 LIMIT 2 [ RunTime:0.006467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63091158 ORDER BY `minOrder` ASC [ RunTime:0.002727s ]
select * from pdf where partno='PRT1.5S-M0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1.5S-M0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000881s ]
SELECT `id` FROM `stock` WHERE `id` <> 63091158 AND `partno` = 'PRT1.5S-M0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407338 [ RunTime:0.004817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090031 LIMIT 5 [ RunTime:0.003053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090031 ORDER BY `minOrder` ASC [ RunTime:0.013554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090031 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090031 LIMIT 2 [ RunTime:0.018126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090031 ORDER BY `minOrder` ASC [ RunTime:0.005389s ]
select * from pdf where partno='PRT12EH-C0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT12EH-C0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.007568s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090031 AND `partno` = 'PRT12EH-C0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.013197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536295 [ RunTime:0.015112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090029 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090029 ORDER BY `minOrder` ASC [ RunTime:0.003863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090029 ORDER BY `unit` DESC [ RunTime:0.023337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090029 LIMIT 2 [ RunTime:0.009302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090029 ORDER BY `minOrder` ASC [ RunTime:0.013500s ]
select * from pdf where partno='PRT10EH-C0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT10EH-C0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.004968s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090029 AND `partno` = 'PRT10EH-C0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.029073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536291 [ RunTime:0.013913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089947 LIMIT 5 [ RunTime:0.007251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089947 ORDER BY `minOrder` ASC [ RunTime:0.013497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089947 ORDER BY `unit` DESC [ RunTime:0.001882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089947 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089947 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='PRT1S-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1S-C' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089947 AND `partno` = 'PRT1S-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.003520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536919 [ RunTime:0.008009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089898 LIMIT 5 [ RunTime:0.003810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089898 ORDER BY `minOrder` ASC [ RunTime:0.017931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089898 ORDER BY `unit` DESC [ RunTime:0.002492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089898 LIMIT 2 [ RunTime:0.006446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089898 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='PRT1S-M0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1S-M0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001633s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089898 AND `partno` = 'PRT1S-M0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.001430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537920 [ RunTime:0.000823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089879 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089879 ORDER BY `minOrder` ASC [ RunTime:0.001949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089879 ORDER BY `unit` DESC [ RunTime:0.006394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089879 LIMIT 2 [ RunTime:0.005598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089879 ORDER BY `minOrder` ASC [ RunTime:0.002720s ]
select * from pdf where partno='PRT1.5S-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PRT1.5S-M' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001884s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089879 AND `partno` = 'PRT1.5S-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.001303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420725 [ RunTime:0.002937s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001651s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002283s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003255s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001752s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001159s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024637s ]
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 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007221s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PRT1%' OR `brand` LIKE 'PRT1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001405s ]