SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508484 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508484 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382804,986995,375369,196102,623666,752129,1023701,633021,646335,54576,900985,221527,257030,805589,709793,498657,847944,677410,614243,918994,13604,575440,536107,1015800,276330,1034629,345589,635834,181,995665,95143,151022,211016,729856,311713,869274,28823,899598,863742,288614,918585,879798,11705,481486,788807,288335,834280,832111,561884,148999,532185,544598,872882,710131,89749,803449,511331,762667,107905,543774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]