SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40203 LIMIT 1 [ RunTime:0.001557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40203 [ RunTime:0.004443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262550,1045918,86639,737777,692911,455456,560497,337596,157979,613257,639169,159143,237428,264107,787843,809541,320079,863640,762383,124832,776062,382626,820178,143934,876914,482888,142926,505047,783837,183018,357518,776125,826705,919629,624753,809531,738678,755412,513593,653520,1030051,672417,616595,356326,247085,236310,933859,556442,1034148,1033099,712591,788791,553413,968739,648996,881993,691909,1007658,27160,559248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]