SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580461 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580461 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008418,768840,800378,806241,822312,301305,995324,411879,679995,492721,564460,1001373,549300,899799,492217,673105,563116,266078,452540,133122,459387,941063,733979,486963,351916,991118,750772,45528,878408,396578,450158,533495,467810,588931,317603,149358,360664,445988,724230,119033,433435,856690,976507,835016,749121,1005792,76135,607030,950085,704569,651150,376706,782113,316690,847948,489771,668034,432889,795880,272748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]