SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302004 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302004 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875283,470608,139251,918130,521593,319455,110913,930673,966521,484055,37261,82194,98340,62729,136449,531517,521219,81443,568540,824047,892682,166553,391948,321564,398846,947846,463930,17670,35978,302561,484566,555322,338443,334740,672329,597663,994011,100781,483748,105111,58300,90113,726668,196683,640336,550102,561863,362866,217992,65495,60590,1011582,371672,31957,366411,800323,791433,206467,391845,94470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]