SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34138 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34138 [ RunTime:0.004298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148379,444823,872527,192467,408668,307867,510445,656452,590620,1030604,813527,112327,689391,584542,377574,680534,990587,410019,545787,751042,701342,213883,232913,473743,809610,1029862,290233,106751,242886,870894,606161,841644,135427,366177,716714,490606,166175,675866,669697,447463,990682,153244,760016,679139,792936,575435,716964,105379,266232,644907,869997,238541,675368,935667,203667,150596,907162,190173,914197,902084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]