SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402276 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402276 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404816,566032,170498,723596,433549,735215,71326,284898,864914,219753,479420,145505,408027,188377,797336,1047507,673271,219259,258533,758642,1022093,524305,171842,969988,934789,187751,1046273,964583,784052,648858,542158,1027556,945240,888175,186202,769434,537226,183281,901521,1029161,499006,434000,511603,439353,285633,325208,485120,592683,1034912,726940,818768,651948,315079,334936,556011,288853,225966,26290,1009483,904399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]