SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 625178 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 625178 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643473,303483,1011784,559636,854496,858746,791387,528814,888357,904036,857898,513387,564682,1002393,13426,142460,840137,332879,924115,614354,376756,764008,188525,1010364,996371,362480,333280,987915,888644,589792,638961,975068,576004,203773,971147,607413,890475,228978,194662,392014,979823,843463,757386,634153,130298,1004001,710300,438886,904030,678456,80011,413273,821357,362365,674295,903210,104966,661669,392367,778130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 625178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 625178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]