SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357284 LIMIT 1 [ RunTime:0.001453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357284 [ RunTime:0.002759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267098,339682,352443,444044,778996,371704,997661,654093,148053,47890,601136,205585,54840,481732,52929,390531,672950,723210,217668,241863,646740,104,215964,99293,502267,547017,817869,357615,97730,811642,121244,730962,117868,628225,681360,712681,391354,743154,648858,133368,332584,419285,485435,889590,981084,116925,704046,404630,800610,537852,108547,359581,521390,740415,524274,271721,294922,365560,1040516,227950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]