SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 650104 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 650104 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251044,668910,392843,971,19379,306952,619957,248173,728657,823760,787302,859622,156931,418603,183377,660514,71658,565772,127973,627297,413809,200214,332097,122566,544952,200215,389462,110399,667594,33946,124767,55407,410099,344381,237370,589902,307857,316687,60348,804981,860234,413922,450957,616728,344048,779200,658427,434023,621382,500912,221302,745623,833594,331890,414215,568317,442201,490272,509942,194462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 650104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 650104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]