SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474221 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474221 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17101,169741,968221,562481,728516,376942,138067,1007944,342202,426217,826476,916354,636203,1044943,352346,750121,142709,957738,239191,52456,769264,157207,584978,591284,224648,497218,16148,760737,1013628,150915,553598,970115,180334,335098,176204,284416,112937,895738,223133,9562,1027079,560148,591106,184490,950557,945969,847271,919754,434144,50062,365967,461105,473446,722756,43034,280738,923637,336747,288450,172198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]