SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550053 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550053 [ RunTime:0.002935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374002,558672,377590,452303,751241,827714,94071,316813,569945,207195,424808,514169,755470,394343,1022471,657479,564031,135770,90878,893545,867529,90700,205577,508614,499659,321440,805847,186219,1028591,337581,883532,986666,464298,1024577,715437,992807,587952,935115,884147,218621,466202,951179,612099,246785,967844,515964,803960,803208,657115,929904,664250,934526,413847,574287,348815,418148,1019460,1027128,614624,891507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]