SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910401 LIMIT 1 [ RunTime:0.002244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910401 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350525,818178,734047,219103,801865,1007400,631707,702060,217921,193258,483089,589647,958686,385030,380496,61115,28064,463761,45165,25061,679358,244948,625477,99478,24835,198890,918742,510102,672784,652967,918505,927222,976018,507669,813461,762842,68609,1047945,227740,224639,161578,309115,286378,816079,470758,525599,643125,456828,111204,868405,890414,712247,31729,927320,1001305,223613,712634,247653,570422,214033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]