SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505704 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505704 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242754,449950,870067,471864,195376,338034,988990,851307,949761,904364,944839,541892,601129,220905,680386,647170,661113,901600,635823,240238,66416,894036,441756,135663,744184,356405,822241,660810,1001379,629465,19763,983713,875685,3350,361838,874780,237670,378387,374344,981627,721975,521791,600563,838813,403314,306209,56625,713387,510603,714869,629299,1003427,454143,308066,132414,558699,605480,653144,85633,502556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]