SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001831s ]
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=GX-H15B&search=1' [ RunTime:0.002931s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001528s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000765s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001845s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004974s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001918s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003456s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002733s ]
SELECT * FROM `stock_search` WHERE `partno` = 'GX-H15B' LIMIT 1 [ RunTime:0.014953s ]
UPDATE `stock_search` SET `count` = 18 , `updatetime` = '2026-08-20 03:07:52' WHERE `partno` = 'GX-H15B' [ RunTime:0.015511s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003940s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004355s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791553 LIMIT 5 [ RunTime:0.005010s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791553 ORDER BY `minOrder` ASC [ RunTime:0.003453s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791553 ORDER BY `unit` DESC [ RunTime:0.008773s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791553 LIMIT 2 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791553 ORDER BY `minOrder` ASC [ RunTime:0.006197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791890 LIMIT 5 [ RunTime:0.005782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791890 ORDER BY `minOrder` ASC [ RunTime:0.002436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791890 ORDER BY `unit` DESC [ RunTime:0.005923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791890 LIMIT 2 [ RunTime:0.008522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791890 ORDER BY `minOrder` ASC [ RunTime:0.002844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791889 LIMIT 5 [ RunTime:0.003664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791889 ORDER BY `minOrder` ASC [ RunTime:0.013450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791889 ORDER BY `unit` DESC [ RunTime:0.003202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791889 LIMIT 2 [ RunTime:0.001598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791889 ORDER BY `minOrder` ASC [ RunTime:0.003329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791895 LIMIT 5 [ RunTime:0.003634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791895 ORDER BY `minOrder` ASC [ RunTime:0.002253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791895 ORDER BY `unit` DESC [ RunTime:0.002837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791895 LIMIT 2 [ RunTime:0.015224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791895 ORDER BY `minOrder` ASC [ RunTime:0.006358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791894 LIMIT 5 [ RunTime:0.013122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791894 ORDER BY `minOrder` ASC [ RunTime:0.020680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791894 ORDER BY `unit` DESC [ RunTime:0.001481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791894 LIMIT 2 [ RunTime:0.008032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791894 ORDER BY `minOrder` ASC [ RunTime:0.007704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791893 LIMIT 5 [ RunTime:0.012299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791893 ORDER BY `minOrder` ASC [ RunTime:0.011436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791893 ORDER BY `unit` DESC [ RunTime:0.010168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791893 LIMIT 2 [ RunTime:0.005147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791893 ORDER BY `minOrder` ASC [ RunTime:0.023400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791556 LIMIT 5 [ RunTime:0.008312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791556 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791556 ORDER BY `unit` DESC [ RunTime:0.005970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791556 LIMIT 2 [ RunTime:0.007042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791556 ORDER BY `minOrder` ASC [ RunTime:0.003712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791555 LIMIT 5 [ RunTime:0.015638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791555 ORDER BY `minOrder` ASC [ RunTime:0.008623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791555 ORDER BY `unit` DESC [ RunTime:0.011795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791555 LIMIT 2 [ RunTime:0.012414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791555 ORDER BY `minOrder` ASC [ RunTime:0.029410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17013253 LIMIT 5 [ RunTime:0.006677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17013253 ORDER BY `minOrder` ASC [ RunTime:0.007416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17013253 ORDER BY `unit` DESC [ RunTime:0.008651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17013253 LIMIT 2 [ RunTime:0.024746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17013253 ORDER BY `minOrder` ASC [ RunTime:0.008426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227492 LIMIT 5 [ RunTime:0.000266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227492 ORDER BY `minOrder` ASC [ RunTime:0.006822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15227492 ORDER BY `unit` DESC [ RunTime:0.005429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15227492 LIMIT 2 [ RunTime:0.011039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227492 ORDER BY `minOrder` ASC [ RunTime:0.004312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227491 LIMIT 5 [ RunTime:0.002984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227491 ORDER BY `minOrder` ASC [ RunTime:0.010009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15227491 ORDER BY `unit` DESC [ RunTime:0.017009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15227491 LIMIT 2 [ RunTime:0.020335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227491 ORDER BY `minOrder` ASC [ RunTime:0.002456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227490 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227490 ORDER BY `minOrder` ASC [ RunTime:0.015069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15227490 ORDER BY `unit` DESC [ RunTime:0.009614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15227490 LIMIT 2 [ RunTime:0.003306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15227490 ORDER BY `minOrder` ASC [ RunTime:0.040850s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32238961 LIMIT 5 [ RunTime:0.006411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32238961 ORDER BY `minOrder` ASC [ RunTime:0.015224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32238961 ORDER BY `unit` DESC [ RunTime:0.002876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32238961 LIMIT 2 [ RunTime:0.002052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32238961 ORDER BY `minOrder` ASC [ RunTime:0.002587s ]
select * from pdf where partno='gx-h15b' and brandshort='panasonic industrial automation' limit 1 [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gx-h15b' OR `brand` LIKE 'panasonic industrial automation%' ) ) LIMIT 1 [ RunTime:0.001944s ]
SELECT `id` FROM `stock` WHERE `id` <> 32238961 AND `partno` = 'gx-h15b' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation%' ) [ RunTime:0.004148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791555 [ RunTime:0.000277s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785422 LIMIT 5 [ RunTime:0.002478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785422 ORDER BY `minOrder` ASC [ RunTime:0.005197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785422 ORDER BY `unit` DESC [ RunTime:0.008178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785422 LIMIT 2 [ RunTime:0.005820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785422 ORDER BY `minOrder` ASC [ RunTime:0.005361s ]
select * from pdf where partno='GX-H15BI-R' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.002512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15BI-R' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.002071s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785422 AND `partno` = 'GX-H15BI-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.004233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791890 [ RunTime:0.005272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785421 LIMIT 5 [ RunTime:0.004125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785421 ORDER BY `minOrder` ASC [ RunTime:0.001467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785421 ORDER BY `unit` DESC [ RunTime:0.001954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785421 LIMIT 2 [ RunTime:0.003341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785421 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
select * from pdf where partno='GX-H15BI-C5' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.001494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15BI-C5' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.012487s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785421 AND `partno` = 'GX-H15BI-C5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.005602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791889 [ RunTime:0.011804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787174 LIMIT 5 [ RunTime:0.000802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787174 ORDER BY `minOrder` ASC [ RunTime:0.004533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787174 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787174 LIMIT 2 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787174 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='GX-H15B-R' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15B-R' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000312s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787174 AND `partno` = 'GX-H15B-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791895 [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787017 LIMIT 5 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787017 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787017 ORDER BY `unit` DESC [ RunTime:0.000312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787017 LIMIT 2 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787017 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='GX-H15BI-P' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15BI-P' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000308s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787017 AND `partno` = 'GX-H15BI-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17013253 [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786295 LIMIT 5 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786295 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786295 ORDER BY `unit` DESC [ RunTime:0.000306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786295 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786295 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
select * from pdf where partno='GX-H15B-P-C5' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15B-P-C5' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000329s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786295 AND `partno` = 'GX-H15B-P-C5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791894 [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786288 LIMIT 5 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786288 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786288 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786288 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786288 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='GX-H15BI' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15BI' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000318s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786288 AND `partno` = 'GX-H15BI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791556 [ RunTime:0.000309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786287 LIMIT 5 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786287 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786287 ORDER BY `unit` DESC [ RunTime:0.000313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786287 LIMIT 2 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786287 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='GX-H15B' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15B' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000307s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786287 AND `partno` = 'GX-H15B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791555 [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787181 LIMIT 5 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787181 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787181 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787181 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787181 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='GX-H15B-P-R' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15B-P-R' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000311s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787181 AND `partno` = 'GX-H15B-P-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227492 [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787180 LIMIT 5 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787180 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787180 ORDER BY `unit` DESC [ RunTime:0.000306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787180 LIMIT 2 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787180 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
select * from pdf where partno='GX-H15BI-P-R' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15BI-P-R' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000306s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787180 AND `partno` = 'GX-H15BI-P-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227491 [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787179 LIMIT 5 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787179 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787179 ORDER BY `unit` DESC [ RunTime:0.000300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787179 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787179 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='GX-H15BI-P-C5' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15BI-P-C5' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000309s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787179 AND `partno` = 'GX-H15BI-P-C5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227490 [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787178 LIMIT 5 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787178 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787178 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787178 LIMIT 2 [ RunTime:0.002579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787178 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='GX-H15B-C5' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15B-C5' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000311s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787178 AND `partno` = 'GX-H15B-C5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791893 [ RunTime:0.001209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785896 LIMIT 5 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785896 ORDER BY `minOrder` ASC [ RunTime:0.010915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785896 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785896 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785896 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='GX-H15B-P' and brandshort='Panasonic Industrial Automation Sales' limit 1 [ RunTime:0.000410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GX-H15B-P' OR `brand` LIKE 'Panasonic Industrial Automation Sales%' ) ) LIMIT 1 [ RunTime:0.000330s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785896 AND `partno` = 'GX-H15B-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic industrial automation sales%' ) [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791553 [ RunTime:0.000308s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003168s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009925s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002065s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001749s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002101s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003898s ]
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 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001202s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'GX-H15B%' OR `brand` LIKE 'GX-H15B%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013360s ]