SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002449s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=EHRJ45D6A&search=1' [ RunTime:0.002919s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002897s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000607s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003618s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.008930s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002112s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011887s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002420s ]
SELECT * FROM `stock_search` WHERE `partno` = 'EHRJ45D6A' LIMIT 1 [ RunTime:0.000869s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-15 21:32:52' WHERE `partno` = 'EHRJ45D6A' [ RunTime:0.006082s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001280s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043511s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076481 LIMIT 5 [ RunTime:0.047012s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076481 ORDER BY `minOrder` ASC [ RunTime:0.012826s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.025505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20076481 ORDER BY `unit` DESC [ RunTime:0.026551s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.025830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20076481 LIMIT 2 [ RunTime:0.033828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076481 ORDER BY `minOrder` ASC [ RunTime:0.041407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371015 LIMIT 5 [ RunTime:0.071630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371015 ORDER BY `minOrder` ASC [ RunTime:0.054068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17371015 ORDER BY `unit` DESC [ RunTime:0.029821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17371015 LIMIT 2 [ RunTime:0.082918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371015 ORDER BY `minOrder` ASC [ RunTime:0.024415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15547703 LIMIT 5 [ RunTime:0.034152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15547703 ORDER BY `minOrder` ASC [ RunTime:0.060753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15547703 ORDER BY `unit` DESC [ RunTime:0.026512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15547703 LIMIT 2 [ RunTime:0.098217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15547703 ORDER BY `minOrder` ASC [ RunTime:0.013868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076493 LIMIT 5 [ RunTime:0.033153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076493 ORDER BY `minOrder` ASC [ RunTime:0.079287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20076493 ORDER BY `unit` DESC [ RunTime:0.049252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20076493 LIMIT 2 [ RunTime:0.052820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076493 ORDER BY `minOrder` ASC [ RunTime:0.029832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356634 LIMIT 5 [ RunTime:0.064181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356634 ORDER BY `minOrder` ASC [ RunTime:0.068730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16356634 ORDER BY `unit` DESC [ RunTime:0.041676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16356634 LIMIT 2 [ RunTime:0.028021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356634 ORDER BY `minOrder` ASC [ RunTime:0.031426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076603 LIMIT 5 [ RunTime:0.045115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076603 ORDER BY `minOrder` ASC [ RunTime:0.048244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20076603 ORDER BY `unit` DESC [ RunTime:0.010032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20076603 LIMIT 2 [ RunTime:0.014142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076603 ORDER BY `minOrder` ASC [ RunTime:0.029930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356616 LIMIT 5 [ RunTime:0.023545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356616 ORDER BY `minOrder` ASC [ RunTime:0.011207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16356616 ORDER BY `unit` DESC [ RunTime:0.060263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16356616 LIMIT 2 [ RunTime:0.039245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356616 ORDER BY `minOrder` ASC [ RunTime:0.013185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076535 LIMIT 5 [ RunTime:0.048580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076535 ORDER BY `minOrder` ASC [ RunTime:0.009755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20076535 ORDER BY `unit` DESC [ RunTime:0.041751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20076535 LIMIT 2 [ RunTime:0.054412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076535 ORDER BY `minOrder` ASC [ RunTime:0.033041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356682 LIMIT 5 [ RunTime:0.024962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356682 ORDER BY `minOrder` ASC [ RunTime:0.043217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16356682 ORDER BY `unit` DESC [ RunTime:0.030059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16356682 LIMIT 2 [ RunTime:0.054380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356682 ORDER BY `minOrder` ASC [ RunTime:0.029708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076533 LIMIT 5 [ RunTime:0.030177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076533 ORDER BY `minOrder` ASC [ RunTime:0.063048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20076533 ORDER BY `unit` DESC [ RunTime:0.046705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20076533 LIMIT 2 [ RunTime:0.027192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20076533 ORDER BY `minOrder` ASC [ RunTime:0.024447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371137 LIMIT 5 [ RunTime:0.056853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371137 ORDER BY `minOrder` ASC [ RunTime:0.052357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17371137 ORDER BY `unit` DESC [ RunTime:0.026105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17371137 LIMIT 2 [ RunTime:0.037119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371137 ORDER BY `minOrder` ASC [ RunTime:0.007372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371134 LIMIT 5 [ RunTime:0.022510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371134 ORDER BY `minOrder` ASC [ RunTime:0.055757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17371134 ORDER BY `unit` DESC [ RunTime:0.060722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17371134 LIMIT 2 [ RunTime:0.078234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371134 ORDER BY `minOrder` ASC [ RunTime:0.049979s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279307 LIMIT 5 [ RunTime:0.041586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279307 ORDER BY `minOrder` ASC [ RunTime:0.025446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279307 ORDER BY `unit` DESC [ RunTime:0.016792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279307 LIMIT 2 [ RunTime:0.066200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279307 ORDER BY `minOrder` ASC [ RunTime:0.024253s ]
select * from pdf where partno='ehrj45d6a440' and brandshort='switchcraft' limit 1 [ RunTime:0.040687s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ehrj45d6a440' OR `brand` LIKE 'switchcraft%' ) ) LIMIT 1 [ RunTime:0.023963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279251 LIMIT 5 [ RunTime:0.080136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279251 ORDER BY `minOrder` ASC [ RunTime:0.054188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279251 ORDER BY `unit` DESC [ RunTime:0.064993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279251 LIMIT 2 [ RunTime:0.066989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279251 ORDER BY `minOrder` ASC [ RunTime:0.023335s ]
select * from pdf where partno='ehrj45d6a440' and brandshort='switchcraft' limit 1 [ RunTime:0.010862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ehrj45d6a440' OR `brand` LIKE 'switchcraft%' ) ) LIMIT 1 [ RunTime:0.014249s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618109 LIMIT 5 [ RunTime:0.024915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618109 ORDER BY `minOrder` ASC [ RunTime:0.028483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618109 ORDER BY `unit` DESC [ RunTime:0.020097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618109 LIMIT 2 [ RunTime:0.030728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618109 ORDER BY `minOrder` ASC [ RunTime:0.018593s ]
select * from pdf where partno='EHRJ45D6ASB440' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.018859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6ASB440' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.007953s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618109 AND `partno` = 'EHRJ45D6ASB440' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.024238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076535 [ RunTime:0.033863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618105 LIMIT 5 [ RunTime:0.016027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618105 ORDER BY `minOrder` ASC [ RunTime:0.020774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618105 ORDER BY `unit` DESC [ RunTime:0.037200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618105 LIMIT 2 [ RunTime:0.017334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618105 ORDER BY `minOrder` ASC [ RunTime:0.011816s ]
select * from pdf where partno='EHRJ45D6AS' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.029630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6AS' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.025575s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618105 AND `partno` = 'EHRJ45D6AS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.018502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356616 [ RunTime:0.020859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618221 LIMIT 5 [ RunTime:0.010679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618221 ORDER BY `minOrder` ASC [ RunTime:0.020469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618221 ORDER BY `unit` DESC [ RunTime:0.021668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618221 LIMIT 2 [ RunTime:0.006619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618221 ORDER BY `minOrder` ASC [ RunTime:0.016956s ]
select * from pdf where partno='EHRJ45D6AB440' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.005210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6AB440' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.008128s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618221 AND `partno` = 'EHRJ45D6AB440' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.004252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076481 [ RunTime:0.026201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618499 LIMIT 5 [ RunTime:0.015572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618499 ORDER BY `minOrder` ASC [ RunTime:0.024141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618499 ORDER BY `unit` DESC [ RunTime:0.018790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618499 LIMIT 2 [ RunTime:0.046182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618499 ORDER BY `minOrder` ASC [ RunTime:0.028904s ]
select * from pdf where partno='EHRJ45D6AM3' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.034718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6AM3' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.017670s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618499 AND `partno` = 'EHRJ45D6AM3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.032524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076603 [ RunTime:0.027492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618423 LIMIT 5 [ RunTime:0.010367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618423 ORDER BY `minOrder` ASC [ RunTime:0.034252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618423 ORDER BY `unit` DESC [ RunTime:0.028306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618423 LIMIT 2 [ RunTime:0.023484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618423 ORDER BY `minOrder` ASC [ RunTime:0.014596s ]
select * from pdf where partno='EHRJ45D6ASB' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.018767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6ASB' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.020454s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618423 AND `partno` = 'EHRJ45D6ASB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.043044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076493 [ RunTime:0.042237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618500 LIMIT 5 [ RunTime:0.015688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618500 ORDER BY `minOrder` ASC [ RunTime:0.034549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618500 ORDER BY `unit` DESC [ RunTime:0.030463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618500 LIMIT 2 [ RunTime:0.014426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618500 ORDER BY `minOrder` ASC [ RunTime:0.028021s ]
select * from pdf where partno='EHRJ45D6AB' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.018091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6AB' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.081358s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618500 AND `partno` = 'EHRJ45D6AB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.059400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356682 [ RunTime:0.045412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618355 LIMIT 5 [ RunTime:0.030065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618355 ORDER BY `minOrder` ASC [ RunTime:0.042572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618355 ORDER BY `unit` DESC [ RunTime:0.029250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618355 LIMIT 2 [ RunTime:0.089813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618355 ORDER BY `minOrder` ASC [ RunTime:0.047395s ]
select * from pdf where partno='EHRJ45D6AS440' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.023822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6AS440' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.028513s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618355 AND `partno` = 'EHRJ45D6AS440' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.025896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20076533 [ RunTime:0.025261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618805 LIMIT 5 [ RunTime:0.026532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618805 ORDER BY `minOrder` ASC [ RunTime:0.082565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618805 ORDER BY `unit` DESC [ RunTime:0.023800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618805 LIMIT 2 [ RunTime:0.038875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618805 ORDER BY `minOrder` ASC [ RunTime:0.031151s ]
select * from pdf where partno='EHRJ45D6A440' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.048472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6A440' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.034443s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618805 AND `partno` = 'EHRJ45D6A440' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.077033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371137 [ RunTime:0.065890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618802 LIMIT 5 [ RunTime:0.080759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618802 ORDER BY `minOrder` ASC [ RunTime:0.061907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618802 ORDER BY `unit` DESC [ RunTime:0.076493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618802 LIMIT 2 [ RunTime:0.060255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618802 ORDER BY `minOrder` ASC [ RunTime:0.003645s ]
select * from pdf where partno='EHRJ45D6A' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.043375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6A' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.032861s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618802 AND `partno` = 'EHRJ45D6A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.077421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371134 [ RunTime:0.039856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618579 LIMIT 5 [ RunTime:0.073237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618579 ORDER BY `minOrder` ASC [ RunTime:0.068007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618579 ORDER BY `unit` DESC [ RunTime:0.043671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618579 LIMIT 2 [ RunTime:0.039945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618579 ORDER BY `minOrder` ASC [ RunTime:0.015447s ]
select * from pdf where partno='EHRJ45D6ASBM3' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.052638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6ASBM3' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.169332s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618579 AND `partno` = 'EHRJ45D6ASBM3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.115949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356634 [ RunTime:0.087436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618578 LIMIT 5 [ RunTime:0.069225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618578 ORDER BY `minOrder` ASC [ RunTime:0.062309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618578 ORDER BY `unit` DESC [ RunTime:0.066895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618578 LIMIT 2 [ RunTime:0.036267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618578 ORDER BY `minOrder` ASC [ RunTime:0.032640s ]
select * from pdf where partno='EHRJ45D6ABM3' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.109883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6ABM3' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.021066s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618578 AND `partno` = 'EHRJ45D6ABM3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.033359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371015 [ RunTime:0.036186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60618577 LIMIT 5 [ RunTime:0.054524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618577 ORDER BY `minOrder` ASC [ RunTime:0.069378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60618577 ORDER BY `unit` DESC [ RunTime:0.028717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60618577 LIMIT 2 [ RunTime:0.023291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60618577 ORDER BY `minOrder` ASC [ RunTime:0.046984s ]
select * from pdf where partno='EHRJ45D6ASM3' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.011293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHRJ45D6ASM3' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.011733s ]
SELECT `id` FROM `stock` WHERE `id` <> 60618577 AND `partno` = 'EHRJ45D6ASM3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.024497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15547703 [ RunTime:0.049985s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023335s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045695s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043978s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080800s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027209s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030313s ]
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 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018217s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EHRJ45D6A%' OR `brand` LIKE 'EHRJ45D6A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.035800s ]