SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515618 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515618 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19516,529959,282641,1043802,2999,414405,901369,982865,356429,497839,63575,140699,704742,1018334,775138,671310,808082,647566,506316,178140,328655,570401,816011,412008,707905,560844,795371,1016499,239288,770370,257894,988355,873207,419156,115416,391922,962056,460978,882240,625160,530739,479999,827458,329967,287733,896303,1003439,736512,901008,100745,446953,674403,477091,971418,906610,195920,810967,211517,195094,605970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]