SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54622 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54622 [ RunTime:0.002793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033222,281414,376114,227525,847183,908713,683352,506545,917359,746661,744870,86964,1045119,901652,367041,433990,194704,773588,535324,1030280,131677,740148,710150,39537,427036,609642,709530,246234,329074,140359,659424,370547,287374,391549,308774,174101,394476,52639,1006709,237213,292208,113298,853589,778387,609384,153521,744795,125231,401831,1035090,879414,201933,856808,675286,123373,97393,383575,659203,481781,70876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]