SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44903 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44903 [ RunTime:0.003123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260422,1016891,560240,717486,167901,689747,997025,439122,7643,893367,101084,291439,53584,67294,500695,794727,811654,347244,389423,556579,1017139,806907,674010,643740,276729,455969,991184,216818,252340,322727,147314,859237,1047629,531333,95977,629102,1027520,289154,564244,637274,309471,596008,653158,902560,20354,413933,548215,578481,489435,943962,593845,353787,189144,60563,106106,719082,740084,367434,1021786,804908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]