SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515743 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515743 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010284,874191,810685,912189,300021,901968,65003,350634,429092,1006215,722413,450297,659622,568283,777518,174193,322182,821849,755431,380249,405935,982103,523727,613667,26197,862161,556165,503349,384886,665608,453948,301840,626497,395872,480525,779249,603884,67502,516640,418717,153494,226387,125568,666155,105865,728007,264362,136416,206966,942789,889847,233931,616367,1042812,334472,794693,749131,897917,17097,161204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]