SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427598 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427598 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495051,532938,660909,126061,363691,395722,222165,166392,698401,727035,253151,791988,563227,186071,24247,322731,168844,379243,1020796,612117,524757,534260,252162,573085,699332,776155,592535,1135,236968,426678,164534,90383,354563,575724,311609,561441,762148,733295,345212,282096,496460,198579,606777,131938,1048545,591534,380012,362686,26866,987333,927246,154146,291155,247821,796069,336280,159682,262135,1004176,734730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]