SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555180 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555180 [ RunTime:0.005022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322365,837733,585239,501505,380121,129635,1043129,640405,394320,783630,176637,464439,928690,13283,718986,1033317,2380,154176,125984,480267,67678,553869,679490,43519,609225,471492,321712,409119,215581,478317,18263,681868,84874,746133,993780,975665,954454,27523,607570,288872,469227,768854,953906,866025,594774,490688,336089,1010730,180733,580474,332541,368398,904746,666609,307532,693204,74663,725544,509777,200776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]