SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367612 LIMIT 1 [ RunTime:0.000692s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367612 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204633,108080,127013,376013,647029,2664,414492,350431,869107,531225,418294,886019,504935,70470,871943,458315,471464,696015,306446,231893,731757,577147,450206,811883,867392,327642,93195,209112,768994,210696,360891,327654,750496,465581,408474,269276,500909,431698,196725,118846,433763,428838,321252,70661,125725,949792,254460,399823,481601,74402,567843,529294,539180,407144,1023249,1002290,877306,589010,537763,118372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]