SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807881 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807881 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106821,925290,474700,353607,953663,760090,219288,1011655,442468,477699,516515,788321,226671,652543,519460,910401,715971,915676,317913,103973,390767,532596,414235,137038,217199,111000,889276,147391,271923,1006946,327334,399380,740576,627969,558709,778924,631736,575548,685743,846116,594176,983822,266020,76304,832779,908251,735016,168041,152750,640241,450656,435441,189438,59081,35893,151298,1013145,7682,132630,952963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001218s ]