SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297411 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297411 [ RunTime:0.003325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776241,812003,672110,365320,205511,718074,479682,329267,345023,952377,315005,957723,446368,812512,813796,709113,546889,526092,706216,465103,972840,112371,331728,739567,400813,379728,917335,517238,335668,667715,91993,998879,418271,793986,702778,662352,730297,605572,254565,449422,145840,984742,193337,791484,846051,944558,260950,240290,711086,970679,11645,546955,420273,552339,182891,904388,729759,788787,750691,829025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]