SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26106 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26106 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281098,687362,65056,302203,554837,263474,26358,703183,227541,200058,538216,858696,683143,192957,1043259,581576,286431,834914,803827,1037608,390769,351060,67562,875810,794498,528229,868791,977345,179221,282496,115313,1046632,668158,925348,500527,723833,1039017,797884,36208,308277,640186,471817,307887,479258,48260,784899,604764,982327,871487,726638,579150,641606,508157,5562,918355,579380,57402,662385,795005,82989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]