SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174100 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174100 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410922,632886,961258,742398,864715,188562,697696,142564,579176,763574,734283,161049,28202,629946,240339,304391,920141,964405,333390,219679,68200,787843,153587,965983,949222,213667,236717,761982,33586,14506,656539,605330,650934,636243,174265,125108,132593,115254,606292,695394,1028402,775361,54692,17239,235216,102696,436774,944492,589997,480332,279913,712510,72688,560376,29617,353394,43442,820386,1028161,141582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]