SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566065 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566065 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104457,122266,25460,924288,949081,215600,40688,208709,245965,442990,794104,756450,161800,922931,612701,1023319,138654,921925,688144,930733,468890,2396,368729,161290,34168,858367,120407,157119,658715,834750,579230,415511,63459,447644,796566,902459,807725,390677,748110,531675,738998,445415,972631,834326,882271,73349,714830,612313,537537,7427,49390,573807,711906,800960,8593,253762,223755,124624,920351,899292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]