SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001879s ]
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=SK2&search=1' [ RunTime:0.006168s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001409s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000618s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002823s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.002402s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002291s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002204s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SK2' LIMIT 1 [ RunTime:0.002109s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-16 18:57:49' WHERE `partno` = 'SK2' [ RunTime:0.010345s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002486s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010851s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14896468 LIMIT 5 [ RunTime:0.014126s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14896468 ORDER BY `minOrder` ASC [ RunTime:0.001520s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14896468 ORDER BY `unit` DESC [ RunTime:0.001047s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14896468 LIMIT 2 [ RunTime:0.001321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14896468 ORDER BY `minOrder` ASC [ RunTime:0.008920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894105 LIMIT 5 [ RunTime:0.018441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894105 ORDER BY `minOrder` ASC [ RunTime:0.009946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14894105 ORDER BY `unit` DESC [ RunTime:0.007028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14894105 LIMIT 2 [ RunTime:0.021552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894105 ORDER BY `minOrder` ASC [ RunTime:0.004195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13983226 LIMIT 5 [ RunTime:0.009194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13983226 ORDER BY `minOrder` ASC [ RunTime:0.007245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13983226 ORDER BY `unit` DESC [ RunTime:0.018827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13983226 LIMIT 2 [ RunTime:0.025976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13983226 ORDER BY `minOrder` ASC [ RunTime:0.016581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894083 LIMIT 5 [ RunTime:0.019251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894083 ORDER BY `minOrder` ASC [ RunTime:0.012296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14894083 ORDER BY `unit` DESC [ RunTime:0.017956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14894083 LIMIT 2 [ RunTime:0.029445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894083 ORDER BY `minOrder` ASC [ RunTime:0.012490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894082 LIMIT 5 [ RunTime:0.028992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894082 ORDER BY `minOrder` ASC [ RunTime:0.017400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14894082 ORDER BY `unit` DESC [ RunTime:0.058283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14894082 LIMIT 2 [ RunTime:0.043396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894082 ORDER BY `minOrder` ASC [ RunTime:0.011639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13977804 LIMIT 5 [ RunTime:0.039467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13977804 ORDER BY `minOrder` ASC [ RunTime:0.024325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13977804 ORDER BY `unit` DESC [ RunTime:0.068127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13977804 LIMIT 2 [ RunTime:0.071550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13977804 ORDER BY `minOrder` ASC [ RunTime:0.005011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13974687 LIMIT 5 [ RunTime:0.027293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13974687 ORDER BY `minOrder` ASC [ RunTime:0.042277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13974687 ORDER BY `unit` DESC [ RunTime:0.000719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13974687 LIMIT 2 [ RunTime:0.009131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13974687 ORDER BY `minOrder` ASC [ RunTime:0.004255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14904090 LIMIT 5 [ RunTime:0.021985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14904090 ORDER BY `minOrder` ASC [ RunTime:0.007729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14904090 ORDER BY `unit` DESC [ RunTime:0.017247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14904090 LIMIT 2 [ RunTime:0.009281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14904090 ORDER BY `minOrder` ASC [ RunTime:0.023706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13977007 LIMIT 5 [ RunTime:0.009088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13977007 ORDER BY `minOrder` ASC [ RunTime:0.008339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13977007 ORDER BY `unit` DESC [ RunTime:0.005236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13977007 LIMIT 2 [ RunTime:0.008732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13977007 ORDER BY `minOrder` ASC [ RunTime:0.022838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13974580 LIMIT 5 [ RunTime:0.006449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13974580 ORDER BY `minOrder` ASC [ RunTime:0.012286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13974580 ORDER BY `unit` DESC [ RunTime:0.004372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13974580 LIMIT 2 [ RunTime:0.013327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13974580 ORDER BY `minOrder` ASC [ RunTime:0.008082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14892802 LIMIT 5 [ RunTime:0.016812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14892802 ORDER BY `minOrder` ASC [ RunTime:0.032293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14892802 ORDER BY `unit` DESC [ RunTime:0.005567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14892802 LIMIT 2 [ RunTime:0.042866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14892802 ORDER BY `minOrder` ASC [ RunTime:0.004492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16727230 LIMIT 5 [ RunTime:0.006283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16727230 ORDER BY `minOrder` ASC [ RunTime:0.019667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16727230 ORDER BY `unit` DESC [ RunTime:0.003004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16727230 LIMIT 2 [ RunTime:0.002629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16727230 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13979998 LIMIT 5 [ RunTime:0.006511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13979998 ORDER BY `minOrder` ASC [ RunTime:0.015720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13979998 ORDER BY `unit` DESC [ RunTime:0.005641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13979998 LIMIT 2 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13979998 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986132 LIMIT 5 [ RunTime:0.004163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13986132 ORDER BY `minOrder` ASC [ RunTime:0.015693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13986132 ORDER BY `unit` DESC [ RunTime:0.005414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13986132 LIMIT 2 [ RunTime:0.001463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13986132 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14893049 LIMIT 5 [ RunTime:0.003735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14893049 ORDER BY `minOrder` ASC [ RunTime:0.003549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14893049 ORDER BY `unit` DESC [ RunTime:0.001954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14893049 LIMIT 2 [ RunTime:0.024918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14893049 ORDER BY `minOrder` ASC [ RunTime:0.006194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14892705 LIMIT 5 [ RunTime:0.010844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14892705 ORDER BY `minOrder` ASC [ RunTime:0.010431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14892705 ORDER BY `unit` DESC [ RunTime:0.008739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14892705 LIMIT 2 [ RunTime:0.002493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14892705 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14902618 LIMIT 5 [ RunTime:0.003576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14902618 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14902618 ORDER BY `unit` DESC [ RunTime:0.000592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14902618 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14902618 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034289 LIMIT 5 [ RunTime:0.000980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034289 ORDER BY `minOrder` ASC [ RunTime:0.002689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034289 ORDER BY `unit` DESC [ RunTime:0.000931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034289 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034289 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034299 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034299 ORDER BY `minOrder` ASC [ RunTime:0.004173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034299 ORDER BY `unit` DESC [ RunTime:0.003398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034299 LIMIT 2 [ RunTime:0.020115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034299 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976747 LIMIT 5 [ RunTime:0.002320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976747 ORDER BY `minOrder` ASC [ RunTime:0.000678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13976747 ORDER BY `unit` DESC [ RunTime:0.002522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13976747 LIMIT 2 [ RunTime:0.003570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976747 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51029719 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51029719 ORDER BY `minOrder` ASC [ RunTime:0.002964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51029719 ORDER BY `unit` DESC [ RunTime:0.003624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51029719 LIMIT 2 [ RunTime:0.007607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51029719 ORDER BY `minOrder` ASC [ RunTime:0.002144s ]
select * from pdf where partno='sk230rtp' and brandshort='littelfuse' limit 1 [ RunTime:0.003685s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sk230rtp' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.017892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51029718 LIMIT 5 [ RunTime:0.008302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51029718 ORDER BY `minOrder` ASC [ RunTime:0.006656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51029718 ORDER BY `unit` DESC [ RunTime:0.000671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51029718 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51029718 ORDER BY `minOrder` ASC [ RunTime:0.001518s ]
select * from pdf where partno='sk230nrp' and brandshort='littelfuse' limit 1 [ RunTime:0.001174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sk230nrp' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.009736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263765 LIMIT 5 [ RunTime:0.004806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263765 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32263765 ORDER BY `unit` DESC [ RunTime:0.001724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32263765 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263765 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
select * from pdf where partno='sk2-095h02' and brandshort='anderson power products' limit 1 [ RunTime:0.000879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sk2-095h02' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.005289s ]
SELECT `id` FROM `stock` WHERE `id` <> 32263765 AND `partno` = 'sk2-095h02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.011648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32179283 [ RunTime:0.001098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12626438 [ RunTime:0.006103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32179283 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32179283 ORDER BY `minOrder` ASC [ RunTime:0.009669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32179283 ORDER BY `unit` DESC [ RunTime:0.002309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32179283 LIMIT 2 [ RunTime:0.004795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32179283 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='sk2-095h02' and brandshort='anderson power products' limit 1 [ RunTime:0.003243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sk2-095h02' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.000512s ]
SELECT `id` FROM `stock` WHERE `id` <> 32179283 AND `partno` = 'sk2-095h02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.006474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263765 [ RunTime:0.002548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12626438 [ RunTime:0.002586s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080761 LIMIT 5 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080761 ORDER BY `minOrder` ASC [ RunTime:0.008210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080761 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080761 LIMIT 2 [ RunTime:0.008886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080761 ORDER BY `minOrder` ASC [ RunTime:0.005221s ]
select * from pdf where partno='SK26A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.008501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK26A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.001309s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080761 AND `partno` = 'SK26A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.001713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079332 LIMIT 5 [ RunTime:0.004864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079332 ORDER BY `minOrder` ASC [ RunTime:0.013506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44079332 ORDER BY `unit` DESC [ RunTime:0.000787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44079332 LIMIT 2 [ RunTime:0.008092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079332 ORDER BY `minOrder` ASC [ RunTime:0.001846s ]
select * from pdf where partno='SK220A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.007206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK220A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.007387s ]
SELECT `id` FROM `stock` WHERE `id` <> 44079332 AND `partno` = 'SK220A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.004583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083775 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083775 ORDER BY `minOrder` ASC [ RunTime:0.001626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083775 ORDER BY `unit` DESC [ RunTime:0.004224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083775 LIMIT 2 [ RunTime:0.007333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083775 ORDER BY `minOrder` ASC [ RunTime:0.006848s ]
select * from pdf where partno='SK26' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.004638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK26' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.001552s ]
SELECT `id` FROM `stock` WHERE `id` <> 44083775 AND `partno` = 'SK26' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080680 LIMIT 5 [ RunTime:0.001652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080680 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080680 ORDER BY `unit` DESC [ RunTime:0.026826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080680 LIMIT 2 [ RunTime:0.011271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080680 ORDER BY `minOrder` ASC [ RunTime:0.005447s ]
select * from pdf where partno='SK210' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.008481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK210' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.015015s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080680 AND `partno` = 'SK210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.020361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080987 LIMIT 5 [ RunTime:0.014752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080987 ORDER BY `minOrder` ASC [ RunTime:0.012116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080987 ORDER BY `unit` DESC [ RunTime:0.003709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080987 LIMIT 2 [ RunTime:0.005461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080987 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='SK210' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.014804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK210' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.043451s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080987 AND `partno` = 'SK210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.017003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083660 LIMIT 5 [ RunTime:0.014466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083660 ORDER BY `minOrder` ASC [ RunTime:0.010719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083660 ORDER BY `unit` DESC [ RunTime:0.047403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083660 LIMIT 2 [ RunTime:0.029057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083660 ORDER BY `minOrder` ASC [ RunTime:0.012511s ]
select * from pdf where partno='SK24A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.022490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK24A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.012307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083776 LIMIT 5 [ RunTime:0.028455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083776 ORDER BY `minOrder` ASC [ RunTime:0.026131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083776 ORDER BY `unit` DESC [ RunTime:0.009535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083776 LIMIT 2 [ RunTime:0.020111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083776 ORDER BY `minOrder` ASC [ RunTime:0.018243s ]
select * from pdf where partno='SK23' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.033693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK23' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.028368s ]
SELECT `id` FROM `stock` WHERE `id` <> 44083776 AND `partno` = 'SK23' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.026464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091316 LIMIT 5 [ RunTime:0.006895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091316 ORDER BY `minOrder` ASC [ RunTime:0.025663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091316 ORDER BY `unit` DESC [ RunTime:0.030324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091316 LIMIT 2 [ RunTime:0.025076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091316 ORDER BY `minOrder` ASC [ RunTime:0.002434s ]
select * from pdf where partno='SK2C0A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.020288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK2C0A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.010506s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091316 AND `partno` = 'SK2C0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.008614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091184 LIMIT 5 [ RunTime:0.021146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091184 ORDER BY `minOrder` ASC [ RunTime:0.016278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091184 ORDER BY `unit` DESC [ RunTime:0.000923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091184 LIMIT 2 [ RunTime:0.003192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091184 ORDER BY `minOrder` ASC [ RunTime:0.002278s ]
select * from pdf where partno='SK25A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.002416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK25A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009613s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091184 AND `partno` = 'SK25A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.013331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080510 LIMIT 5 [ RunTime:0.014931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080510 ORDER BY `minOrder` ASC [ RunTime:0.012184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080510 ORDER BY `unit` DESC [ RunTime:0.009439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080510 LIMIT 2 [ RunTime:0.013477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080510 ORDER BY `minOrder` ASC [ RunTime:0.001287s ]
select * from pdf where partno='SK24' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.007657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK24' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001205s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080510 AND `partno` = 'SK24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.012095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39248932 LIMIT 5 [ RunTime:0.009135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39248932 ORDER BY `minOrder` ASC [ RunTime:0.010811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39248932 ORDER BY `unit` DESC [ RunTime:0.003431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39248932 LIMIT 2 [ RunTime:0.001566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39248932 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='SK2R2M050ST' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.002771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK2R2M050ST' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.002189s ]
SELECT `id` FROM `stock` WHERE `id` <> 39248932 AND `partno` = 'SK2R2M050ST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.009624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894105 [ RunTime:0.005845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083779 LIMIT 5 [ RunTime:0.006019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083779 ORDER BY `minOrder` ASC [ RunTime:0.001131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083779 ORDER BY `unit` DESC [ RunTime:0.000580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083779 LIMIT 2 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083779 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='SK26A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.007920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK26A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.001609s ]
SELECT `id` FROM `stock` WHERE `id` <> 44083779 AND `partno` = 'SK26A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39230597 LIMIT 5 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39230597 ORDER BY `minOrder` ASC [ RunTime:0.010289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39230597 ORDER BY `unit` DESC [ RunTime:0.014630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39230597 LIMIT 2 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39230597 ORDER BY `minOrder` ASC [ RunTime:0.003563s ]
select * from pdf where partno='SK2R2M063ST' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.002293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK2R2M063ST' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.005037s ]
SELECT `id` FROM `stock` WHERE `id` <> 39230597 AND `partno` = 'SK2R2M063ST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.006315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14896468 [ RunTime:0.004139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091798 LIMIT 5 [ RunTime:0.001419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091798 ORDER BY `minOrder` ASC [ RunTime:0.003132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091798 ORDER BY `unit` DESC [ RunTime:0.001302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091798 LIMIT 2 [ RunTime:0.015440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091798 ORDER BY `minOrder` ASC [ RunTime:0.003299s ]
select * from pdf where partno='SK28' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.001119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK28' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002056s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091798 AND `partno` = 'SK28' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.000955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083651 [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44086507 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086507 ORDER BY `minOrder` ASC [ RunTime:0.001186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44086507 ORDER BY `unit` DESC [ RunTime:0.010998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44086507 LIMIT 2 [ RunTime:0.002481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086507 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
select * from pdf where partno='SK29A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK29A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003282s ]
SELECT `id` FROM `stock` WHERE `id` <> 44086507 AND `partno` = 'SK29A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44086623 LIMIT 5 [ RunTime:0.013419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086623 ORDER BY `minOrder` ASC [ RunTime:0.002633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44086623 ORDER BY `unit` DESC [ RunTime:0.001071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44086623 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086623 ORDER BY `minOrder` ASC [ RunTime:0.000176s ]
select * from pdf where partno='SK23AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK23AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000409s ]
SELECT `id` FROM `stock` WHERE `id` <> 44086623 AND `partno` = 'SK23AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091124 LIMIT 5 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091124 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091124 ORDER BY `unit` DESC [ RunTime:0.000899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091124 LIMIT 2 [ RunTime:0.000766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091124 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='SK2BA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.001428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK2BA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003271s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091124 AND `partno` = 'SK2BA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.004408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091188 LIMIT 5 [ RunTime:0.006553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091188 ORDER BY `minOrder` ASC [ RunTime:0.002190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091188 ORDER BY `unit` DESC [ RunTime:0.002659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091188 LIMIT 2 [ RunTime:0.002335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091188 ORDER BY `minOrder` ASC [ RunTime:0.001190s ]
select * from pdf where partno='SK23A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.001380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK23A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003648s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091188 AND `partno` = 'SK23A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.006467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091526 LIMIT 5 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091526 ORDER BY `minOrder` ASC [ RunTime:0.002488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091526 ORDER BY `unit` DESC [ RunTime:0.002272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091526 LIMIT 2 [ RunTime:0.000812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091526 ORDER BY `minOrder` ASC [ RunTime:0.000183s ]
select * from pdf where partno='SK26' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.001783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK26' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002358s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091526 AND `partno` = 'SK26' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.001991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091229 LIMIT 5 [ RunTime:0.000785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091229 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091229 ORDER BY `unit` DESC [ RunTime:0.002931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091229 LIMIT 2 [ RunTime:0.001831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091229 ORDER BY `minOrder` ASC [ RunTime:0.001934s ]
select * from pdf where partno='SK29A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.002938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK29A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000631s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091229 AND `partno` = 'SK29A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.000488s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000621s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000496s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003712s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001299s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002542s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005081s ]
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 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32119640 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32119640 ORDER BY `minOrder` ASC [ RunTime:0.017586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32119640 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32119640 LIMIT 2 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32119640 ORDER BY `minOrder` ASC [ RunTime:0.000179s ]
select * from pdf where partno='SK22D02G4' and brandshort='HanElectricity' limit 1 [ RunTime:0.000875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK22D02G4' OR `brand` LIKE 'HanElectricity(瀚源)%' ) ) LIMIT 1 [ RunTime:0.005322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32135261 LIMIT 5 [ RunTime:0.002716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32135261 ORDER BY `minOrder` ASC [ RunTime:0.002061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32135261 ORDER BY `unit` DESC [ RunTime:0.006972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32135261 LIMIT 2 [ RunTime:0.001511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32135261 ORDER BY `minOrder` ASC [ RunTime:0.005149s ]
select * from pdf where partno='SK22D02G4' and brandshort='HanElectricity' limit 1 [ RunTime:0.000503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK22D02G4' OR `brand` LIKE 'HanElectricity(瀚源)%' ) ) LIMIT 1 [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58024320 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58024320 ORDER BY `minOrder` ASC [ RunTime:0.001718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58024320 ORDER BY `unit` DESC [ RunTime:0.013172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58024320 LIMIT 2 [ RunTime:0.004485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58024320 ORDER BY `minOrder` ASC [ RunTime:0.000200s ]
select * from pdf where partno='SK22D02L3' and brandshort='XKB Connection' limit 1 [ RunTime:0.000842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK22D02L3' OR `brand` LIKE 'XKB Connection(中国星坤)%' ) ) LIMIT 1 [ RunTime:0.008766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58023702 LIMIT 5 [ RunTime:0.007601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58023702 ORDER BY `minOrder` ASC [ RunTime:0.001655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58023702 ORDER BY `unit` DESC [ RunTime:0.005668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58023702 LIMIT 2 [ RunTime:0.001278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58023702 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
select * from pdf where partno='SK22D02L4' and brandshort='XKB Connection' limit 1 [ RunTime:0.000726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK22D02L4' OR `brand` LIKE 'XKB Connection(中国星坤)%' ) ) LIMIT 1 [ RunTime:0.007145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32134864 LIMIT 5 [ RunTime:0.004695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32134864 ORDER BY `minOrder` ASC [ RunTime:0.005351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32134864 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32134864 LIMIT 2 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32134864 ORDER BY `minOrder` ASC [ RunTime:0.000214s ]
select * from pdf where partno='SK22D02L5' and brandshort='XKB Connection' limit 1 [ RunTime:0.000869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK22D02L5' OR `brand` LIKE 'XKB Connection(中国星坤)%' ) ) LIMIT 1 [ RunTime:0.005734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44124919 LIMIT 5 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44124919 ORDER BY `minOrder` ASC [ RunTime:0.003222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44124919 ORDER BY `unit` DESC [ RunTime:0.006258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44124919 LIMIT 2 [ RunTime:0.001315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44124919 ORDER BY `minOrder` ASC [ RunTime:0.007274s ]
select * from pdf where partno='SK22D02L5' and brandshort='XKB Connection' limit 1 [ RunTime:0.000498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK22D02L5' OR `brand` LIKE 'XKB Connection(中国星坤)%' ) ) LIMIT 1 [ RunTime:0.000283s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SK2%' OR `brand` LIKE 'SK2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001414s ]