SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000514 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000514 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36686,744354,252555,1918,538863,222607,536953,1029874,797650,178540,231404,409224,816883,1004831,769312,127174,353235,91097,784004,371554,622326,245956,620847,592703,47088,1035217,783540,583054,565418,306109,727218,897765,249649,703775,1023709,248148,225973,863043,774121,218539,422627,661681,547716,3874,982957,984204,523143,378095,578591,782274,596194,509578,749151,512221,656177,842537,864713,528665,839423,246204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]