SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809794 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809794 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577501,559012,306273,498553,126093,736164,242610,154826,235206,359331,763574,877203,628850,608561,73445,594289,123915,1048866,108453,276930,479625,228238,151851,356288,537823,681316,792164,428416,529983,656165,902176,141249,75421,992041,1029466,560081,57699,337172,128027,595259,589640,389153,281423,147221,328585,443092,292387,617064,597392,41858,2008,709741,410735,776946,725624,518944,83680,947719,249772,880033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]