SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003729s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105257 LIMIT 1 [ RunTime:0.003649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105257 [ RunTime:0.005573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386048,392172,207153,1042053,719903,423813,802221,144409,1047094,530572,13683,33897,580934,191249,547275,597733,28490,540821,808609,364233,590834,846927,225835,666769,203143,499673,164407,110759,437258,586395,485551,1022566,83387,745704,702201,809301,1012875,689610,544068,68720,101011,561004,691971,953400,273851,627781,590864,549466,882332,444967,277042,539451,142757,717963,316678,99820,965948,434289,924481,822625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]