SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551212 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551212 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692956,669442,76340,377079,226756,950962,166757,263769,385155,1005164,329914,980068,662383,668163,636460,101248,376441,340465,259512,797730,954325,1009294,1038319,627923,458893,1027730,785224,265410,871533,632792,31161,304818,538422,1047148,655053,165649,857131,144796,803149,295744,176342,216375,1010935,725294,254217,305006,180124,494511,548726,504447,923209,1011522,87175,524227,262545,708559,950541,376106,405627,201451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]