SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416573 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416573 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514151,971039,1009014,293472,458644,967382,1038733,14330,207457,760710,595595,134992,239455,1020590,633873,941205,165310,199782,382591,459153,988313,875895,85901,49001,878363,820805,689529,663269,189936,386924,13655,661081,240873,399395,575172,263631,325109,721016,669684,782469,426091,693434,608353,230659,270463,857263,208195,952455,892709,683108,1043414,1019178,475540,425305,71071,613344,76471,359822,647486,63932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]