SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477803 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477803 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410295,601422,1038277,27125,699032,630692,323949,490453,707904,759345,109275,284848,607339,822845,252271,309898,316101,199823,899878,537565,47986,392815,999166,363551,1037990,26,115526,3121,769139,468800,348623,153577,724305,900415,178455,922124,706395,982908,283183,649638,729603,556227,42239,947680,471300,843446,27972,99695,528073,391194,172010,105916,61401,631115,1002637,350106,583849,777816,583843,44158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]