SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398996 LIMIT 1 [ RunTime:0.001027s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398996 [ RunTime:0.002424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805728,723376,427028,452207,1026695,427853,127538,980784,81917,225312,650161,128084,282430,815101,143942,464999,7673,981282,261627,416997,612818,45884,592477,712853,475742,270964,404269,56323,1035959,444897,575457,932520,934232,548379,707602,707512,683339,772667,73676,958936,468826,75311,260543,989861,493250,526081,111233,393529,615374,45179,477884,335815,577207,245195,166010,117268,447120,498775,676782,550469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000850s ]