SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004528 LIMIT 1 [ RunTime:0.004160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004528 [ RunTime:0.003548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473523,73629,368494,1012813,381079,465055,1020750,898890,956689,585537,143393,445313,625847,787977,36005,687671,600878,408833,204549,813595,829250,719773,568291,490793,368528,492703,714218,30356,697036,443706,531419,244214,989498,466562,606317,88895,643194,369466,77481,137966,276097,554360,9964,93027,247655,1024278,562000,798417,702887,793548,755588,399865,437978,589186,203939,233387,1013043,919006,449166,748779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]