SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566797 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566797 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042176,313769,595520,27479,222598,60781,1030888,497820,12773,326869,627092,508633,275593,890055,964919,87290,664249,112849,1016720,838989,701942,352099,940494,536897,596726,78566,799971,148086,685532,284301,122756,73815,260442,174214,171999,90036,1044102,893545,60895,1019982,484132,408382,978113,740918,304557,468415,667170,827289,572598,1004613,440034,831000,211787,338441,469192,759565,730284,625349,859134,759418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]