SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541605 LIMIT 1 [ RunTime:0.001027s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541605 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766562,957725,981049,823419,353972,1038477,1006146,728623,554126,561108,907086,249756,931975,69831,510723,670177,1045887,274102,747228,279277,418889,811464,417285,525556,426698,828602,671006,382909,285887,131839,468990,1000892,1048668,890387,382612,187745,120264,198713,789256,871517,426780,188827,368326,11022,198395,102716,176242,768438,957427,10004,782576,846836,878827,11741,410465,327495,763656,853867,766837,329747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]