SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418088 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418088 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239680,522994,788493,1037242,544141,777582,1026914,506138,67664,343803,816985,482016,342044,920284,853118,273866,1028822,661804,438837,537390,855155,924627,327034,700093,829906,604707,815659,653468,60646,1007001,172217,734383,81607,747938,888927,314458,802632,524999,457623,961179,122065,956164,463177,472451,23825,325194,115518,581479,121754,601215,1034178,821878,367262,51853,551135,580696,838372,331526,391493,484516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003086s ]