SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367860 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367860 [ RunTime:0.002097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321767,896490,444383,642906,200955,255160,15250,202396,1038297,757299,956627,62152,821025,478556,876981,872438,546716,891159,155379,890401,690072,738509,382884,605257,684640,117682,77246,1009852,1019840,595406,404330,969355,147837,437056,869159,913766,242493,235488,260898,887562,665673,727099,582763,562627,11284,929586,823369,352293,830511,647464,582299,301590,433431,727761,1031464,116486,347669,684770,870944,756796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]