SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671533 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671533 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545153,12332,454981,137685,166529,609357,963269,102994,989740,941747,157009,795596,107643,4479,1007725,1040685,742198,486457,114173,688331,197100,1038509,844395,826412,971232,973919,675271,136580,629063,369053,402879,661728,668259,576094,1016144,720382,737312,684540,952769,404072,341092,855126,934453,1046401,225838,591107,849364,256407,201269,717566,967268,582087,205716,1002304,883272,907620,109548,436817,220817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]