SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025106 LIMIT 1 [ RunTime:0.001257s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025106 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272358,226677,44225,196223,529844,275704,820340,78268,932543,794801,777848,861851,856413,598806,919026,328589,612036,809393,95409,299756,1021745,801995,112490,1041249,1030513,174451,546820,926665,674101,725903,624123,112551,872333,14672,980111,269819,794785,646658,223673,63845,103358,443679,547194,178906,467725,93391,716781,963722,132074,803592,973329,731356,800404,406749,273502,409573,545222,606373,92239,966540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]