SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008641 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008641 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350660,115925,976207,825381,600801,884189,376309,455321,301910,483641,994745,433330,281208,529170,839790,984101,345179,111884,607978,429139,754523,952883,413056,619792,217281,28892,556383,950768,748456,864875,1000926,62482,663509,452744,447367,1028617,108613,826069,180363,327046,119298,595555,441625,10427,439026,503867,202096,229356,741888,645986,953729,248062,81929,211579,740829,722265,641117,1012859,596210,906714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003465s ]