SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519509 LIMIT 1 [ RunTime:0.001903s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519509 [ RunTime:0.002468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343921,936252,1024363,460760,257178,242496,1037105,830554,509943,72780,855209,206169,363735,843709,1022399,1007267,776846,566599,1023905,20050,632708,134782,405613,977354,182574,78941,373911,266870,490600,799878,480,34886,833296,646237,402309,734181,549170,167817,1009674,808149,516137,744653,868909,854438,454593,260388,667304,129367,532920,52767,176460,798095,619129,502813,693629,155540,391684,656503,419402,811499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]