SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517455 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517455 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035451,617551,772414,910805,453441,367026,97587,637950,907059,472485,183556,899274,843953,530951,451726,976695,119041,208011,780556,239515,420652,396169,356905,250995,726569,19176,60463,49715,451345,318768,671206,429263,1021511,684059,27128,879384,688033,124457,862280,429647,352196,189073,880225,1022488,681191,312712,499616,53662,101858,279834,915285,437719,301437,538730,713942,584915,245777,189281,865575,804303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]