SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418097 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418097 [ RunTime:0.003271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137247,480235,464236,574495,984611,936326,471270,811030,781918,514441,130068,582603,40233,722689,347473,751255,533103,29434,1045004,784776,736120,853050,607662,405849,537050,192624,711499,523429,883740,502995,365740,1034069,960795,477517,548072,860,595382,428685,316527,676500,300791,364940,528134,1041314,1009610,610768,392750,692303,466908,257314,90381,361755,348764,51114,227361,888496,658637,978180,515171,729264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]