SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381089 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381089 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35882,93674,477451,44780,319474,550471,474440,308843,854029,1017541,35014,7757,702527,498409,53395,870277,477166,61744,992660,590556,93608,208292,607395,695485,371368,250698,361573,579950,636243,989557,687668,542022,615740,174567,381661,651005,412635,478708,799565,124755,5419,790403,882391,14142,354984,528645,104667,631123,562275,581554,391915,948208,344933,1024524,161038,855563,850004,806060,873564,21431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]