SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402686 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402686 [ RunTime:0.003511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193006,339874,657813,96621,976783,954479,739503,447662,224192,248883,770397,604350,458901,416076,432673,250572,749094,986155,769790,1020570,983345,345258,247,505770,918549,457606,35464,656645,206087,777750,677036,490063,92110,509287,1046215,285344,717090,170019,459085,908836,866573,515383,964789,595504,866518,529059,209373,127667,172616,458149,897450,268456,479710,26023,175556,14401,225340,370498,969537,268428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]