SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497916 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497916 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112904,484357,110777,322506,506520,1029511,513728,759452,995962,861958,183433,328438,891133,196977,105287,576472,777667,199988,696206,136225,986414,468513,567034,1025471,952603,670058,88557,85141,840636,779901,28395,341027,479691,688458,893249,199986,48447,419534,130609,961569,137579,673248,469522,215735,608116,483510,1037227,447462,387385,574933,428472,136553,1037401,1015920,490915,176236,1039437,949802,773034,655539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]