SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036975 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036975 [ RunTime:0.003750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403254,688064,257230,575466,588418,112131,121391,697647,863572,637772,422396,433829,62842,12036,1011577,282706,416108,567190,16864,133183,741150,237747,76073,240208,815102,577880,150304,914788,846413,601184,66192,831485,953754,638211,649565,710173,699683,91169,894475,325420,765755,826059,488793,523190,358980,593604,174345,925079,570493,190001,451689,883209,31755,886361,490488,1028293,550503,183504,371430,852108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]