SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489350 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489350 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50528,137496,42029,59173,1014580,667773,280051,146805,65514,715060,492236,245250,223198,415780,647820,731065,462005,167365,1043859,168068,117117,4498,739113,240572,594043,865705,142041,816661,124130,517638,452730,329318,934097,1008173,706127,209452,577545,838455,132035,142529,491506,974424,489132,199112,589150,1047422,144811,844289,431073,789370,751089,218479,1011024,436798,7865,292614,127005,159412,695469,370899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489350 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489350 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]