SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019659 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019659 [ RunTime:0.002972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318010,616116,450763,95385,934175,720567,361693,666864,122515,240541,404062,674808,516611,911602,120874,810423,222634,760046,92317,89598,523511,477682,322389,396783,260784,479176,39307,801375,499189,405954,902533,252804,833277,985600,520817,432372,859266,122026,584619,726945,781431,707092,957883,818430,1041030,771082,626598,195267,190576,242809,79881,987267,673807,105728,232850,667078,377175,2928,313504,538584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019659 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019659 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]