SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047447 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047447 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645319,127504,74937,626331,101005,777874,985299,296432,208055,985773,883587,211596,87342,307347,972127,501886,932341,712045,846952,901803,114140,665317,1024943,403815,904237,215846,949021,410733,101712,266472,184930,1045083,713083,987848,108571,411049,746336,10578,701779,797202,270284,476032,797891,1002816,249889,561818,538307,1030330,499735,692674,735430,615183,43916,659601,637568,18650,827013,36661,963642,107062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]