SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002741 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002741 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255779,583321,770357,969298,523035,884980,918653,692023,242718,699734,612067,995864,86345,905698,96498,524377,584594,60124,296961,708816,105154,743148,744081,744234,506317,730410,140199,645183,230872,783406,809025,430829,778161,663458,70846,150474,456365,604382,96493,486216,532652,664042,673649,563285,652081,20965,174212,648431,735792,205195,442335,641732,259890,886257,621002,935265,630922,524816,188729,834899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000933s ]