SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982899 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982899 [ RunTime:0.003122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937898,1024669,681363,409558,675549,449611,398687,436276,48368,836543,465880,900532,102823,135563,217670,275386,912573,47863,541233,922553,632688,672265,545332,984812,419005,214174,765811,645185,139041,536069,426188,406234,282580,585525,472719,918801,661144,8218,820563,653290,326653,793242,206385,768566,867825,261085,477078,388208,578957,934231,123413,24100,554728,340122,303448,70100,253176,235473,184760,789616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005034s ]