SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037243 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037243 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110721,433632,1039214,169126,589265,234832,361424,806647,1007324,658138,561637,449472,556562,470421,938995,732118,857507,208403,974387,302289,82108,921164,787319,922926,342126,42309,951943,45560,258470,1039802,1016115,961795,641033,546882,649741,547815,46036,162676,232788,881680,780523,846040,467265,243903,208478,905754,800679,254747,65810,52223,843829,631943,512122,67291,610457,1006873,505706,440679,354106,976470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]