SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001234s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=PH95&search=1' [ RunTime:0.002522s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002387s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009527s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002644s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.005738s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002332s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002070s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PH95' LIMIT 1 [ RunTime:0.005816s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-21 14:19:25' WHERE `partno` = 'PH95' [ RunTime:0.004063s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002174s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005688s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13371745 LIMIT 5 [ RunTime:0.000766s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371745 ORDER BY `minOrder` ASC [ RunTime:0.002599s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13371745 ORDER BY `unit` DESC [ RunTime:0.008066s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13371745 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371745 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13371746 LIMIT 5 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371746 ORDER BY `minOrder` ASC [ RunTime:0.001540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13371746 ORDER BY `unit` DESC [ RunTime:0.004090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13371746 LIMIT 2 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371746 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368977 LIMIT 5 [ RunTime:0.002496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368977 ORDER BY `minOrder` ASC [ RunTime:0.002309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13368977 ORDER BY `unit` DESC [ RunTime:0.002902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13368977 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368977 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13371754 LIMIT 5 [ RunTime:0.000871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371754 ORDER BY `minOrder` ASC [ RunTime:0.002623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13371754 ORDER BY `unit` DESC [ RunTime:0.001029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13371754 LIMIT 2 [ RunTime:0.000760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371754 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13371755 LIMIT 5 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371755 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13371755 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13371755 LIMIT 2 [ RunTime:0.002044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371755 ORDER BY `minOrder` ASC [ RunTime:0.002753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996812 LIMIT 5 [ RunTime:0.001284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996812 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996812 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996812 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996812 ORDER BY `minOrder` ASC [ RunTime:0.004440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270321 LIMIT 5 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270321 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270321 ORDER BY `unit` DESC [ RunTime:0.001756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270321 LIMIT 2 [ RunTime:0.002455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270321 ORDER BY `minOrder` ASC [ RunTime:0.000741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270318 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270318 ORDER BY `minOrder` ASC [ RunTime:0.004396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270318 ORDER BY `unit` DESC [ RunTime:0.012891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270318 LIMIT 2 [ RunTime:0.003026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270318 ORDER BY `minOrder` ASC [ RunTime:0.008780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13370263 LIMIT 5 [ RunTime:0.008470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13370263 ORDER BY `minOrder` ASC [ RunTime:0.005514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13370263 ORDER BY `unit` DESC [ RunTime:0.003596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13370263 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13370263 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270319 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270319 ORDER BY `minOrder` ASC [ RunTime:0.013994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270319 ORDER BY `unit` DESC [ RunTime:0.003965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270319 LIMIT 2 [ RunTime:0.002067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270319 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13371872 LIMIT 5 [ RunTime:0.002011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371872 ORDER BY `minOrder` ASC [ RunTime:0.000964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13371872 ORDER BY `unit` DESC [ RunTime:0.000542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13371872 LIMIT 2 [ RunTime:0.006474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371872 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11245263 LIMIT 5 [ RunTime:0.003496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11245263 ORDER BY `minOrder` ASC [ RunTime:0.009117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11245263 ORDER BY `unit` DESC [ RunTime:0.005744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11245263 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11245263 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
select * from pdf where partno='PH9500.100NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.001722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13370251 LIMIT 5 [ RunTime:0.004075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13370251 ORDER BY `minOrder` ASC [ RunTime:0.002001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13370251 ORDER BY `unit` DESC [ RunTime:0.015122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13370251 LIMIT 2 [ RunTime:0.004073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13370251 ORDER BY `minOrder` ASC [ RunTime:0.004909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14254871 LIMIT 5 [ RunTime:0.006079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14254871 ORDER BY `minOrder` ASC [ RunTime:0.014117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14254871 ORDER BY `unit` DESC [ RunTime:0.026814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14254871 LIMIT 2 [ RunTime:0.013503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14254871 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368803 LIMIT 5 [ RunTime:0.014419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368803 ORDER BY `minOrder` ASC [ RunTime:0.013052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13368803 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13368803 LIMIT 2 [ RunTime:0.008290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368803 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11245262 LIMIT 5 [ RunTime:0.002515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11245262 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11245262 ORDER BY `unit` DESC [ RunTime:0.003414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11245262 LIMIT 2 [ RunTime:0.018990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11245262 ORDER BY `minOrder` ASC [ RunTime:0.001854s ]
select * from pdf where partno='PH9505.180NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.002479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11245021 LIMIT 5 [ RunTime:0.007818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11245021 ORDER BY `minOrder` ASC [ RunTime:0.010743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11245021 ORDER BY `unit` DESC [ RunTime:0.000775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11245021 LIMIT 2 [ RunTime:0.019647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11245021 ORDER BY `minOrder` ASC [ RunTime:0.013925s ]
select * from pdf where partno='PH9505.100NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12253974 LIMIT 5 [ RunTime:0.002427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12253974 ORDER BY `minOrder` ASC [ RunTime:0.008700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12253974 ORDER BY `unit` DESC [ RunTime:0.003511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12253974 LIMIT 2 [ RunTime:0.005240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12253974 ORDER BY `minOrder` ASC [ RunTime:0.001654s ]
select * from pdf where partno='PH9505.125NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12254070 LIMIT 5 [ RunTime:0.006132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12254070 ORDER BY `minOrder` ASC [ RunTime:0.006785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12254070 ORDER BY `unit` DESC [ RunTime:0.008240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12254070 LIMIT 2 [ RunTime:0.004816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12254070 ORDER BY `minOrder` ASC [ RunTime:0.002736s ]
select * from pdf where partno='PH9505.070NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.002243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12254222 LIMIT 5 [ RunTime:0.000901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12254222 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12254222 ORDER BY `unit` DESC [ RunTime:0.001544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12254222 LIMIT 2 [ RunTime:0.005399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12254222 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='PH9505.050NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.001585s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32239275 LIMIT 5 [ RunTime:0.006134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239275 ORDER BY `minOrder` ASC [ RunTime:0.003380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32239275 ORDER BY `unit` DESC [ RunTime:0.005378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32239275 LIMIT 2 [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239275 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
select * from pdf where partno='ph9505.180nlt' and brandshort='pulse electronics' limit 1 [ RunTime:0.001515s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ph9505.180nlt' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.001230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32239218 LIMIT 5 [ RunTime:0.002413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239218 ORDER BY `minOrder` ASC [ RunTime:0.007912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32239218 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32239218 LIMIT 2 [ RunTime:0.002457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239218 ORDER BY `minOrder` ASC [ RunTime:0.005139s ]
select * from pdf where partno='ph9500.100nlt' and brandshort='pulse electronics' limit 1 [ RunTime:0.005510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ph9500.100nlt' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.011470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32239473 LIMIT 5 [ RunTime:0.003528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239473 ORDER BY `minOrder` ASC [ RunTime:0.001208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32239473 ORDER BY `unit` DESC [ RunTime:0.012037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32239473 LIMIT 2 [ RunTime:0.001717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239473 ORDER BY `minOrder` ASC [ RunTime:0.003401s ]
select * from pdf where partno='ph9505.125nlt' and brandshort='pulse electronics' limit 1 [ RunTime:0.022931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ph9505.125nlt' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.001285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32239466 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239466 ORDER BY `minOrder` ASC [ RunTime:0.011646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32239466 ORDER BY `unit` DESC [ RunTime:0.000841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32239466 LIMIT 2 [ RunTime:0.009561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239466 ORDER BY `minOrder` ASC [ RunTime:0.005247s ]
select * from pdf where partno='ph9505.050nlt' and brandshort='pulse electronics' limit 1 [ RunTime:0.002566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ph9505.050nlt' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.016315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32239496 LIMIT 5 [ RunTime:0.008796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239496 ORDER BY `minOrder` ASC [ RunTime:0.004971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32239496 ORDER BY `unit` DESC [ RunTime:0.001690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32239496 LIMIT 2 [ RunTime:0.007417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239496 ORDER BY `minOrder` ASC [ RunTime:0.006676s ]
select * from pdf where partno='ph9505.070nlt' and brandshort='pulse electronics' limit 1 [ RunTime:0.003403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ph9505.070nlt' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.001398s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267303 LIMIT 5 [ RunTime:0.011269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267303 ORDER BY `minOrder` ASC [ RunTime:0.002257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267303 ORDER BY `unit` DESC [ RunTime:0.002447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267303 LIMIT 2 [ RunTime:0.010825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267303 ORDER BY `minOrder` ASC [ RunTime:0.016887s ]
select * from pdf where partno='PH9572.233NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.005070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.233NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.003201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267304 LIMIT 5 [ RunTime:0.004834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267304 ORDER BY `minOrder` ASC [ RunTime:0.011877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267304 ORDER BY `unit` DESC [ RunTime:0.003513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267304 LIMIT 2 [ RunTime:0.002221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267304 ORDER BY `minOrder` ASC [ RunTime:0.001638s ]
select * from pdf where partno='PH9572.211NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.002792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.211NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267925 LIMIT 5 [ RunTime:0.001537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267925 ORDER BY `minOrder` ASC [ RunTime:0.002352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267925 ORDER BY `unit` DESC [ RunTime:0.009060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267925 LIMIT 2 [ RunTime:0.003322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267925 ORDER BY `minOrder` ASC [ RunTime:0.007423s ]
select * from pdf where partno='PH9572.322NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.001060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.322NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.000932s ]
SELECT `id` FROM `stock` WHERE `id` <> 58267925 AND `partno` = 'PH9572.322NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.011183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368977 [ RunTime:0.004115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267526 LIMIT 5 [ RunTime:0.004654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267526 ORDER BY `minOrder` ASC [ RunTime:0.019354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267526 ORDER BY `unit` DESC [ RunTime:0.007270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267526 LIMIT 2 [ RunTime:0.007535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267526 ORDER BY `minOrder` ASC [ RunTime:0.003078s ]
select * from pdf where partno='PH9572.122ANLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.009983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.122ANLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.008616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267527 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267527 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267527 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267527 LIMIT 2 [ RunTime:0.018887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267527 ORDER BY `minOrder` ASC [ RunTime:0.021283s ]
select * from pdf where partno='PH9572.322ANLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.008066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.322ANLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.013339s ]
SELECT `id` FROM `stock` WHERE `id` <> 58267527 AND `partno` = 'PH9572.322ANLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.013023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13371755 [ RunTime:0.014467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267067 LIMIT 5 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267067 ORDER BY `minOrder` ASC [ RunTime:0.008630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267067 ORDER BY `unit` DESC [ RunTime:0.006173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267067 LIMIT 2 [ RunTime:0.007360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267067 ORDER BY `minOrder` ASC [ RunTime:0.011409s ]
select * from pdf where partno='PH9572.111NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.111NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.002323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58272154 LIMIT 5 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58272154 ORDER BY `minOrder` ASC [ RunTime:0.008443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58272154 ORDER BY `unit` DESC [ RunTime:0.001319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58272154 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58272154 ORDER BY `minOrder` ASC [ RunTime:0.007252s ]
select * from pdf where partno='PH9585.001NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.001268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9585.001NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.002322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58272155 LIMIT 5 [ RunTime:0.002864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58272155 ORDER BY `minOrder` ASC [ RunTime:0.005067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58272155 ORDER BY `unit` DESC [ RunTime:0.003138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58272155 LIMIT 2 [ RunTime:0.004784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58272155 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='PH9585.003NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.002299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9585.003NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.003844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58272156 LIMIT 5 [ RunTime:0.001686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58272156 ORDER BY `minOrder` ASC [ RunTime:0.005666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58272156 ORDER BY `unit` DESC [ RunTime:0.001911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58272156 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58272156 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='PH9585.002NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.008522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9585.002NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.030199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58259600 LIMIT 5 [ RunTime:0.018078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259600 ORDER BY `minOrder` ASC [ RunTime:0.022778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58259600 ORDER BY `unit` DESC [ RunTime:0.015223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58259600 LIMIT 2 [ RunTime:0.004866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259600 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='PH9505.180NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.002522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9505.180NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.003308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267508 LIMIT 5 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267508 ORDER BY `minOrder` ASC [ RunTime:0.008017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267508 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267508 LIMIT 2 [ RunTime:0.005467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267508 ORDER BY `minOrder` ASC [ RunTime:0.008835s ]
select * from pdf where partno='PH9572.122NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.004322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.122NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.003461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58259602 LIMIT 5 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259602 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58259602 ORDER BY `unit` DESC [ RunTime:0.006593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58259602 LIMIT 2 [ RunTime:0.003429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259602 ORDER BY `minOrder` ASC [ RunTime:0.002541s ]
select * from pdf where partno='PH9500.100NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9500.100NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267321 LIMIT 5 [ RunTime:0.002561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267321 ORDER BY `minOrder` ASC [ RunTime:0.005770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267321 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267321 LIMIT 2 [ RunTime:0.002599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267321 ORDER BY `minOrder` ASC [ RunTime:0.003737s ]
select * from pdf where partno='PH9572.233ANLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.233ANLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267322 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267322 ORDER BY `minOrder` ASC [ RunTime:0.008729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267322 ORDER BY `unit` DESC [ RunTime:0.015462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267322 LIMIT 2 [ RunTime:0.002522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267322 ORDER BY `minOrder` ASC [ RunTime:0.001407s ]
select * from pdf where partno='PH9572.211ANLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.008149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.211ANLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.007659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58272359 LIMIT 5 [ RunTime:0.003502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58272359 ORDER BY `minOrder` ASC [ RunTime:0.014506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58272359 ORDER BY `unit` DESC [ RunTime:0.017282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58272359 LIMIT 2 [ RunTime:0.023716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58272359 ORDER BY `minOrder` ASC [ RunTime:0.011217s ]
select * from pdf where partno='PH9585.004NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.011791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9585.004NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.020403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58266914 LIMIT 5 [ RunTime:0.005418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58266914 ORDER BY `minOrder` ASC [ RunTime:0.001234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58266914 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58266914 LIMIT 2 [ RunTime:0.003093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58266914 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
select * from pdf where partno='PH9572.111ANLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.017442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9572.111ANLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.012078s ]
SELECT `id` FROM `stock` WHERE `id` <> 58266914 AND `partno` = 'PH9572.111ANLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.017215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13370263 [ RunTime:0.014253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58259826 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259826 ORDER BY `minOrder` ASC [ RunTime:0.001184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58259826 ORDER BY `unit` DESC [ RunTime:0.006068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58259826 LIMIT 2 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259826 ORDER BY `minOrder` ASC [ RunTime:0.020502s ]
select * from pdf where partno='PH9505.125NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.002249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9505.125NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.005697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58259827 LIMIT 5 [ RunTime:0.003176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259827 ORDER BY `minOrder` ASC [ RunTime:0.001989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58259827 ORDER BY `unit` DESC [ RunTime:0.001295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58259827 LIMIT 2 [ RunTime:0.007488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259827 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='PH9505.070NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9505.070NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.003734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58259741 LIMIT 5 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259741 ORDER BY `minOrder` ASC [ RunTime:0.016486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58259741 ORDER BY `unit` DESC [ RunTime:0.014653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58259741 LIMIT 2 [ RunTime:0.012271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58259741 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='PH9505.100NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9505.100NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58260114 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58260114 ORDER BY `minOrder` ASC [ RunTime:0.001806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58260114 ORDER BY `unit` DESC [ RunTime:0.009287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58260114 LIMIT 2 [ RunTime:0.024588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58260114 ORDER BY `minOrder` ASC [ RunTime:0.009536s ]
select * from pdf where partno='PH9505.050NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH9505.050NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.000979s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002499s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007510s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016256s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003076s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001909s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001127s ]
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 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002636s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PH95%' OR `brand` LIKE 'PH95%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001396s ]