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` = 387515 LIMIT 1 [ RunTime:0.000709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387515 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748746,80839,568792,1024114,306709,429629,520479,652320,519895,235382,1000248,661829,29524,499601,719391,266225,459806,698374,34091,189679,925978,76573,1038506,300374,407622,725293,559566,513181,696327,127683,1027608,79159,440806,780171,786814,336213,338472,659565,872885,345142,714587,881637,178625,549872,900811,83027,369808,24555,120451,376233,700743,601776,783335,544312,651220,293248,945618,752856,605484,653182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]