SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412912 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412912 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269198,701521,594970,667499,24663,768102,194164,24449,257967,110513,635313,873134,60023,970953,1002173,176927,1019586,935905,284777,892899,333924,772345,685040,610439,818400,295441,179868,25756,905238,615698,135837,745479,13194,1228,597585,677248,297589,974476,818632,118015,1036184,884534,1036609,175529,184488,269024,378195,150790,987169,55247,663166,445733,569424,86769,769366,420941,574694,553115,265380,250966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]