SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439108 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439108 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528699,798072,83830,872464,985941,459686,660459,803147,157726,314493,1028335,402202,271352,742768,424022,537083,676940,56902,477599,915445,238909,961848,804131,1011768,52800,523281,115089,421339,854000,54876,575037,436562,984089,337122,209955,13616,999388,264578,654655,960900,294363,934865,492699,111398,239075,745458,704102,1046182,241747,290636,786315,646883,151802,763829,173276,607035,1035904,948314,282824,1020155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]